[Feature] Support contextual table aliasing

[colin-rogers-dbt]

Is this your first time submitting a feature request?

• I have read the expectations for open source contributors
• I have searched the existing issues, and I could not find an existing issue for this feature
• I am requesting a straightforward extension of existing dbt-adapter functionality, rather than a Big Idea better suited to a discussion

Describe the feature

Follow up from: #124

Currently in databases like postgres (at least pre v16) we attempt to inject subqueries with aliases. This can create a poor user experience as when they write something like:

select * from {{ source('my_table') }} as my_source where x=y 

and run with --empty, we produce something like:

select * from {{ source('my_table') }} as _dbt_limit_subq as my_source where x=y 

The duplicate aliases are invalid sql.

The challenge is that in order to know whether the ref already has an alias.

Describe alternatives you've considered

No response

Who will this benefit?

No response

Are you interested in contributing this feature?

No response

Anything else?

No response

[igorvoltaic]

To anyone searching for a quick short term solution:
We used a dirty hack to run our pipelines with --empty. We parse our sql after it compiles here and remove double aliases where it breaks our code.

[gajanand-jm]

facing the same issue

any solution or progress here? we are planning to use --empty for CI