Is your feature request related to a problem or challenge?
Google BigQuery is releasing support for a pipe operator in their supported Sql dialect. See https://cloud.google.com/bigquery/docs/pipe-syntax-guide and https://research.google/pubs/sql-has-problems-we-can-fix-them-pipe-syntax-in-sql/
Databricks seem to be supporting a similar operator https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-qry-select-pipeop.html
Relates to #14514 which is on supporting Sql features that make SQL easier to write and read.
Describe the solution you'd like
Datafusion supports the pipe operator, which will allow writing queries more ergonomically.
Support WHERE, ORDER BY, LIMIT, SELECT, EXTEND pipe operators #17278 Support WHERE, ORDER BY, LIMIT, SELECT, EXTEND pipe operators #17278 Support WHERE, ORDER BY, LIMIT, SELECT, EXTEND pipe operators #17278 Support WHERE, ORDER BY, LIMIT, SELECT, EXTEND pipe operators #17278 Support WHERE, ORDER BY, LIMIT, SELECT, EXTEND pipe operators #17278 feat: add DROP pipe operator support #20864 Support AS, UNION, INTERSECTION, EXCEPT, AGGREGATE pipe operators #17312 Support AS, UNION, INTERSECTION, EXCEPT, AGGREGATE pipe operators #17312 Support AS, UNION, INTERSECTION, EXCEPT, AGGREGATE pipe operators #17312 Support AS, UNION, INTERSECTION, EXCEPT, AGGREGATE pipe operators #17312 Support AS, UNION, INTERSECTION, EXCEPT, AGGREGATE pipe operators #17312 Support JOIN, PIVOT pipe operators #17365 Support JOIN, PIVOT pipe operators #17365
Describe alternatives you've considered
No response
Additional context
No response
Is your feature request related to a problem or challenge?
Google BigQuery is releasing support for a pipe operator in their supported Sql dialect. See https://cloud.google.com/bigquery/docs/pipe-syntax-guide and https://research.google/pubs/sql-has-problems-we-can-fix-them-pipe-syntax-in-sql/
Databricks seem to be supporting a similar operator https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-qry-select-pipeop.html
Relates to #14514 which is on supporting Sql features that make SQL easier to write and read.
Describe the solution you'd like
Datafusion supports the pipe operator, which will allow writing queries more ergonomically.
WHERE,ORDER BY,LIMIT,SELECT,EXTENDpipe operators #17278WHERE,ORDER BY,LIMIT,SELECT,EXTENDpipe operators #17278WHERE,ORDER BY,LIMIT,SELECT,EXTENDpipe operators #17278WHERE,ORDER BY,LIMIT,SELECT,EXTENDpipe operators #17278WHERE,ORDER BY,LIMIT,SELECT,EXTENDpipe operators #17278AS,UNION,INTERSECTION,EXCEPT,AGGREGATEpipe operators #17312AS,UNION,INTERSECTION,EXCEPT,AGGREGATEpipe operators #17312AS,UNION,INTERSECTION,EXCEPT,AGGREGATEpipe operators #17312AS,UNION,INTERSECTION,EXCEPT,AGGREGATEpipe operators #17312AS,UNION,INTERSECTION,EXCEPT,AGGREGATEpipe operators #17312JOIN,PIVOTpipe operators #17365JOIN,PIVOTpipe operators #17365Describe alternatives you've considered
No response
Additional context
No response