DuckDB's "friendly SQL" variant fixes some of these little problems with SQL, including giving the ability to use a column alias in WHERE clauses.

https://duckdb.org/docs/stable/sql/dialect/friendly_sql