[antruok]

The query structure does look nice indeed! The usage of the pipe character feels odd but I suppose there are benefits in the end

[knutwannheden]

I had the same initial reaction regarding the pipe character. But once I started thinking of the query as a pipe (like in the terminal) through which the data flows, where stuff like ORDER BY, SELECT, and GROUP BY are just operators, it started making sense.