Starting from #databricks runtime 12.2 LTS, implicit lateral column aliasing is now supported. This feature enables you to reuse an expression defined...

[Hubert-Dudek]

Starting from #databricks runtime 12.2 LTS, implicit lateral column aliasing is now supported. This feature enables you to reuse an expression defined earlier in the same SELECT list, thus avoiding repetition of the same calculation.

For instance, in a SELECT statement with expressions like:

SELECT

'John' AS name,

'Smith' AS surname,

Concat(name, ' ', surname) AS full_name

the Concat(name, ' ', surname) can be resolved using previously defined 'John' AS name and 'Smith' AS surname.

This makes writing SQL queries easier and more efficient, as you can reference expressions that have already been defined without needing to repeat them."

[Tayyab_Vohra]

@Hubert Dudek​ , I guess this has been updated in recent update right ?

https://docs.databricks.com/release-notes/runtime/12.2.html

[daniel_sahal]

Thanks @Hubert Dudek​ for the info. Now 50% of my subselects can go to the trash 🙂

[Ajay-Pandey]

Informative

Thanks for sharing.