Support SQL pipe operator

[simonvandel]

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

• Limit (Support some of pipe operators #1759)
• Where (Support some of pipe operators #1759)
• OrderBy (Support some of pipe operators #1759)
• Select (Support some of pipe operators #1759)
• Extend (Support some of pipe operators #1759)
• Set (Support some of pipe operators #1759)
• Drop (Support some of pipe operators #1759)
• As (Support some of pipe operators #1759)
• Aggregate (Support some of pipe operators #1759)
• Tablesample (Add support for TABLESAMPLE pipe operator #1860)
• Rename
• Join
• Union
• Intersect
• Except
• Call
• Pivot
• Unpivo