3 ms·

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

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?

self 2y ago
> Why even add the pipe operator? To make it easier for humans to read/write the queries.
bvrmn 2y ago
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.