Google SQL has it now:

It's pretty neat:

    FROM mydataset.Produce
    |> WHERE sales > 0
    |> AGGREGATE SUM(sales) AS total_sales, COUNT(\*) AS num_sales
       GROUP BY item;

Edit: formatting

▲ ryguyrg 2 months ago | parent [-]

note that DuckDB allows that reverse ordering (FROM-first)

FROM table SELECT foo, bar WHERE zoo=“goo”

	▲	viggity 2 months ago \| parent [-]
		it makes intellisense/autocomplete work a hell of a lot easier. LINQ in dotnet does the same thing.