Projections crashes with syntax error when adding multiple projections.

[stephen-up]

Describe the bug

When using the new projections support, it crashes if you try and add more than one projection.

I can see it works when adding a single projection, and works much better than using a post_hook. It doesn't re-run unnecessarily.

Steps to reproduce

1. Add multiple projections to a model.

   projections=[
   {
     'name': 'max_r_n',
     'query': 'select max(received_ts)'
   },
   {
     'name': 'pd_r',
     'query': 'select project_id, domain order by received_ts'
   }
   ],

2. Run it with dbt run

Expected behaviour

Expected to create the projections.

Error

Syntax error: failed at position 346 ('ALTER') ...

It seems like the statements to add the projections are incorrectly being executed as one statement, rather than independently.

Configuration

Environment

• dbt version: 1.8.5
• dbt-clickhouse version: 1.8.2
• Operating system: osx