SQL Pipe Syntax, Now Available In BigQuery And Cloud Logging
SQL has emerged as the industry standard language for database development. Its well-known syntax and established community have made data access genuinely accessible to everyone
Rigid structure: Subqueries or other intricate patterns are needed to accomplish anything else, and a query must adhere to a specific order (SELECT … FROM … WHERE … GROUP BY)
Awkward inside-out data flow: FROM clauses included in subqueries or common table expressions (CTE) are the first step in a query, after which logic is built outward
Verbose, repetitive syntax: Are you sick of seeing the same columns in every subquery and repeatedly in SELECT, GROUP BY, and ORDER BY
It is therefore excited to provide pipe syntax, a ground-breaking invention that enhances SQL in BigQuery and Cloud Logging with the beauty of piped data flow
It can be difficult to learn and accept new languages, especially in large organizations where it is preferable for everyone to utilize the same tools and languages
Because SQL is so effective, it has been the worldwide language of data for 50 years. When it comes to expressing queries as declarative combinations of relational operators, SQL excels in many things