2 ms·
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
by hyperman1 2y 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.
- larodi 2y agookay, now I can see why this so much reminds of CTE