dbt run --empty throws an error for models with aliased refs

[rodrigorabioglio]

Describe the bug

Running dbt run --empty fails for any model that has a aliased relation, due to double aliasing on the compiled sql code.

Steps To Reproduce

1. Create a model with a aliased ref:
   models/aliased_ref_model.sql :

SELECT *
FROM {{ ref('my_model') }} AS table1

2. Run dbt run -s aliased_ref_model --empty
3. Get the error:

_[PARSE_SYNTAX_ERROR] Syntax error at or near 'AS'. SQLSTATE: 42601
... FROM (select * from my_catalog.my_schema.aliased_ref_model where false limit 0) dbt_limit_subq_aliased_ref_model AS table1
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------^^^

Expected behavior

Run without error

System information

The output of dbt --version:

Core:
  - installed: 1.9.0
  - latest:    1.9.1 - Update available!

  Your version of dbt-core is out of date!
  You can find instructions for upgrading here:
  https://docs.getdbt.com/docs/installation

Plugins:
  - databricks: 1.9.1 - Up to date!
  - spark:      1.9.0 - Up to date!

Also fails on dbt-databricks~1.8

The operating system you're using:

MacOS Sequoia 15.2

The output of python --version:
Python 3.12.7

[benc-db]

Have you reported this to core? I'm not sure the databricks adapter controls any of the substitution involved.

[rodrigorabioglio]

Ok Thanks! I'll link this issue on dbt-core!

[rodrigorabioglio]

Reported: dbt-labs/dbt-adapters#199 (comment)