Skip to main content

qualify_derived_table_outputs

Function qualify_derived_table_outputs 

Source
pub fn qualify_derived_table_outputs(expr: Expression) -> Result<Expression>
Expand description

Ensures all unaliased column outputs in subqueries and CTEs get self-aliases.

This is needed for TSQL which requires derived table outputs to be aliased. For example: SELECT c FROM t inside a subquery becomes SELECT c AS c FROM t.

Mirrors Python sqlglot’s qualify_derived_table_outputs function which is applied as a TRANSFORMS preprocessor for Subquery and CTE expressions in the TSQL dialect.