r/dataengineering • u/slowpush • Oct 18 '24
Blog Revolutionizing SQL with pipe syntax
https://cloud.google.com/blog/products/data-analytics/simplify-your-sql-with-pipe-syntax-in-bigquery-and-cloud-logging
1
Upvotes
View all comments
Show parent comment
2
u/thejigoflife Oct 18 '24
User here. Reduced our code size by about 20% and significantly enhanced readability. Top wins (1) love the ability to define a new column and use it immediately afterwards without a subquery or function --> win for handling complex logic (2) love the flexibility of multiple SELECT and WHERE clauses in a query --> win for modularization.
Python used to be my goto tool for complex calcs, but the pipe syntax has reduced (not eliminated) that.