This is a convenient SQL feature that is supported in Databricks: https://docs.databricks.com/aws/en/sql/language-manual/sql-ref-syntax-qry-select-qualify