zlacker

>>heyden+(OP)
Why even add the pipe operator?

If the DB engine is executing the statement out of order, why not allow the statement to be written in any order and let itself figure it out?

>>philip+dCa
Aggregations could be non-commutative in general case and order is important. Filters before and after grouping are also tied to a particular place in the pipeline.