Support SQL pipe operator

[simonvandel]

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.

Describe alternatives you've considered

No response

Additional context

No response

[alamb]

Interesting idea -- the first thing needed is support in sqlparser if we don't alread have it

Thanks for the suggestion

[simonvandel]

Here's a short video presentation by a Google engineer https://www.hytradboi.com/2025/f8582cd3-1e39-43a8-8749-46817b2910cf-pipe-syntax-in-sql-its-time