Adding a comment at the end of a query results in a syntax error

[tevariou]

Describe the bug

Steps to reproduce

1. Add a comment at the last line of a model

select * 
from {{ ref('some_ref') }}
where id = 1 -- some comment

3. Run model
4. Get an error

 Code: 62. DB::Exception: Syntax error: failed at position 15 ('(') (line 1, col 15): (select

Expected behaviour

To not raise a syntax error

Code examples, such as models or profile settings

dbt and/or ClickHouse server logs

Configuration

Environment

• dbt version: 1.7.9
• dbt-clickhouse version: 1.7.3
• clickhouse-driver version (if using native): 0.2.6
• clickhouse-connect version (if using http): 0.7.2
• Python version: 3.10.9
• Operating system: MacOS / Linux

ClickHouse server

• ClickHouse Server version: 23.8
• ClickHouse Server non-default settings, if any:
• CREATE TABLE statements for tables involved:
• Sample data for these tables, use clickhouse-obfuscator if necessary

[tevariou]

related: #212

[emirkmo]

to be clear #212 seems to have not solved the problem.

@tevariou Can you by any chance paste in the compiled code as well as where it actually errors? It seems cutoff.

[tevariou]

@emirkmo
Model

select 
    *
from
    {{ get_source("mimic_iii", 'admissions') }} -- test

Compiled:

select 
    *
from
    `mimic`.`admissions` -- test