Comment by misiek08
1 year ago
Looks like from Elixir. If old SQL syntax will be supported then why not - but this one will introduce a lot less readable queries when multiple JOINs, subqueries and aggs are involved - it is very easy in plain SQL and here they will probably look bad.
Think it’ll be up to the query author to decide what’s most expressive.
Given it’s adding the pipe operator you can always only add it to the part of the query where it makes sense.
A nice sql linter for legibility could be great for this.