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

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

brooklyn-data / dbt_artifacts