BigQuery's New Pipe Query Syntax: Easier to Read, Write, and Maintain
2025-02-13
Google BigQuery introduces a new pipe query syntax that simplifies writing and maintaining SQL queries with a linear structure. This syntax allows applying operators like SELECT, aggregate, GROUP BY, JOIN, and WHERE in any order and any number of times, resulting in clearer and more understandable query logic. It addresses issues in standard SQL such as strict clause ordering, the need for CTEs or nested subqueries for complex queries, and introduces new pipe operators like EXTEND, SET, DROP, and RENAME for greater flexibility in data manipulation.
Development
Pipe Syntax