Get the latest tech news
SQL pipe syntax available in public preview in BigQuery
Pipe query syntax is an extension to GoogleSQL that supports a linear query structure designed to make your queries easier to read, write, and maintain. You can use pipe syntax anywhere you write GoogleSQL.
You can use any number of pipe operators in your query to do things such as select, order, filter, join, or aggregate columns. The EXTEND pipe operator can reference previously used aliases, making the query easier to read and less error prone: You can't include a differential privacy clause in a SELECT statement following a pipe operator.
Or read this on Hacker News
