Comment by hyperman1
1 year ago
This is an extension on top of all existing SQL. The pipe functions more or less as a unix pipe. There is no reordering, but the user selects the order. The core syntax is simply:
query | operator
Which results in a new query that can be piped again. So e.g. this would be valid too:
SELECT id,a,b FROM table WHERE id>1
|WHERE id < 10
Personally, I can see this fix so much SQL pain.
okay, now I can see why this so much reminds of CTE