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."