Revolutionizing SQL with pipe syntax, now available in BigQuery and Cloud Logging

SQL has been the universal language of data for 50 years, but it has some issues like rigid structure, awkward inside-out data flow, and verbose syntax. To address these issues, Google Cloud has introduced pipe syntax, which makes SQL simpler, more concise, and more flexible. Pipe syntax allows queries to start with FROM, supports most standard SQL operators, and can be mixed with standard SQL. It also has no performance or cost hit and can be used in various applications such as ad-hoc analysis, data engineering lifecycle, and applying LLMs and natural language with SQL. Pipe syntax is now available in BigQuery and Cloud Logging, and users can sign up to try it out.