[Bug]: Syntax error while creating all staging models in dbt artifacts

[TanviBhagwat23]

Overview

While implementing dbt artifacts it gives syntax error for all staging models :

SQL compilation error: syntax error line 14 at position 66 unexpected ','. syntax error line 14 at position 115 unexpected 'as'. syntax error line 14 at position 123 unexpected ')'. syntax error line 14 at position 125 unexpected 'as'.
This is due to '-' getting appended instead of || in macro generate_surrogate_key.sql

How to reproduce

Expected behaviour

It was expected to generate below statement instead
select
md5(cast(coalesce(cast(command_invocation_id as TEXT), '') || '-' || coalesce(cast(node_id as TEXT), '') as TEXT)) as model_execution_id

Screenshots

Environment

Results of running dbt --version: 1.2

# Add the results here

Please paste the contents of your packages.yml file here:

packages:
  ...

packages:

• package: dbt-labs/dbt_utils
  version: 0.8.2
• package: dbt-labs/audit_helper
  version: 0.5.0
• package: calogica/dbt_expectations
  version: 0.5.3
• package: dbt-labs/codegen
  version: 0.5.0
• git: "https://github.com/colpal/cp-dbt-standard-package.git"
  revision: v0.1

[TanviBhagwat23]

packages:

• package: dbt-labs/dbt_utils
  version: 0.8.2
• package: dbt-labs/audit_helper
  version: 0.5.0
• package: calogica/dbt_expectations
  version: 0.5.3
• package: dbt-labs/codegen
  version: 0.5.0
• git: "https://github.com/colpal/cp-dbt-standard-package.git"
  revision: v0.1