Unable to run query which end with a single comment

[ndeunk]

Expected behavior

Be able to run a query which ends with a single comment

Actual behavior

Incorrect syntax error

Steps To Reproduce

Create simple model. For example:

select * from {{ source('bronze', 'my_test_table') }} -- My new comment

The genereated SQL has an additional statement on the same line as the comment, causing the error.

select * from renamed -- My new comment order by (select null)
    offset 0 rows fetch first 500 rows only

Log output/Screenshots

('42000', "[42000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Incorrect syntax near '0'. (102) (SQLExecDirectW)")

Operating System

Debian GNU/Linux 11 (bullseye)

dbt version

1.8.3

dbt Adapter

fabric

dbt Power User version

v0.41.4

Are you willing to submit PR?

• Yes I am willing to submit a PR!

[mdesmet]

@ndeunk : Are you able to run this query with dbt show?