Pipe syntax is available in BigQuery for preview. It is a pipe data-flow like syntax to SQL, an extension to GoogleSQL. It supports the same operators as standard syntax, but they can be applied in any order, any number of times, usually without using subqueries. Semantically, they behave the same way as standard syntax, but much easier to write, read and debug queries.
Once you submit this request, you can expect your project to be activated in the US multi-region within 1-2 business days, and the rest of the regions within 7 business days. Thanks!
*For internal users and Cloud Logging customers, you do not need to submit this form as it is automatically available.