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 https://github.com/apache/datafusion/issues/14660 which is the Datafusion part Progress - [x] Limit (https://github.com/apache/datafusion-sqlparser-rs/pull/1759) - [x] Where (https://github.com/apache/datafusion-sqlparser-rs/pull/1759) - [x] OrderBy (https://github.com/apache/datafusion-sqlparser-rs/pull/1759) - [x] Select (https://github.com/apache/datafusion-sqlparser-rs/pull/1759) - [x] Extend (https://github.com/apache/datafusion-sqlparser-rs/pull/1759) - [x] Set (https://github.com/apache/datafusion-sqlparser-rs/pull/1759) - [x] Drop (https://github.com/apache/datafusion-sqlparser-rs/pull/1759) - [x] As (https://github.com/apache/datafusion-sqlparser-rs/pull/1759) - [x] Aggregate (https://github.com/apache/datafusion-sqlparser-rs/pull/1759) - [x] Tablesample (https://github.com/apache/datafusion-sqlparser-rs/pull/1860) - [ ] Rename (https://github.com/apache/datafusion-sqlparser-rs/pull/1879) - [ ] Join (https://github.com/apache/datafusion-sqlparser-rs/pull/1879) - [ ] Union (https://github.com/apache/datafusion-sqlparser-rs/pull/1879) - [ ] Intersect (https://github.com/apache/datafusion-sqlparser-rs/pull/1879) - [ ] Except (https://github.com/apache/datafusion-sqlparser-rs/pull/1879) - [ ] Call (https://github.com/apache/datafusion-sqlparser-rs/pull/1879) - [ ] Pivot (https://github.com/apache/datafusion-sqlparser-rs/pull/1879) - [ ] Unpivot (https://github.com/apache/datafusion-sqlparser-rs/pull/1879)
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 apache/datafusion#14660 which is the Datafusion part
Progress
TABLESAMPLEpipe operator #1860)