[elygre]

Let me reference fields as I create them:

  select xxxxx as a
       , a * 2 as b

[zX41ZdbW]

This will be great! One of the things ClickHouse has had since 2016.

[cyberax]

SQL needs to have `select` as the _last_ part, not the first. LINQ has had this for 2 decades by now: "from table_a as a, table_b as b where ... select a.blah, b.duh".

[cryptonector]

This is not relevant to GP's point. This is a separate topic, which... I don't really care, but I know a lot of people want to be able to write SQL as you suggest, and it's not hard to implement, so, sure.

Though, I think it might have to be table sources, then `SELECT`, then `WHERE`, then ... because you might want to refer to output columns in the `WHERE` clause.

[viraptor]

https://prql-lang.org/ and compile to SQL.

[agnosticmantis]

The Pipe Query Syntax in GoogleSQL implements this elegantly as well:

https://docs.cloud.google.com/bigquery/docs/reference/standa...

[jiggawatts]

Also in the Kusto Query Language (KQL) as used by Azure Log Analytics.