Comment by metadata
Google SQL has it now:
https://cloud.google.com/blog/products/data-analytics/simpli...
It's pretty neat:
FROM mydataset.Produce
|> WHERE sales > 0
|> AGGREGATE SUM(sales) AS total_sales, COUNT(\*) AS num_sales
GROUP BY item;
note that DuckDB allows that reverse ordering (FROM-first)
FROM table SELECT foo, bar WHERE zoo=“goo”