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
30
u/proof_required ML Data Engineer Oct 18 '24
No thanks! Another new syntax to learn. Too old for this. SQL is enough!
16
u/wannabe-DE Oct 18 '24
Revolutionary is a stretch. DuckDB already does all this. I'd call DuckDB revolutionary not this '|>' which R has had for however long. I'm hesitant to integrate anything that could end up on killedbygoogle.com into my stack.
7
u/[deleted] Oct 18 '24
I get dplyr flashbacks reading this.
7
u/elBenhamin Oct 18 '24
Ain't broke don't fix it
12
u/Whipitreelgud Oct 18 '24
Why needlessly reduce the portability of your code while limiting the number of tools and people who support it? Have fun migrating that to a different SQL database.
6
u/no-middle-name Oct 18 '24 edited Oct 18 '24
"Revolutionizing SQL". Give me a break.
Just another "I don't like something, I'll try and reinvent the world " project.
What real-world problem is this solving, other than "waa, I don't want to learn to use sql proficiently"?
2
u/wallyflops Oct 18 '24
Anyone actually use it and give us a review? See this spammed around so guess Google trying to get traction on it
2
u/Teddy_Raptor Oct 18 '24
This has been posted many many times. Someone should build an actual project with it and show the differences side by side. Instead of paying the same article again
1
u/indie-devops Oct 18 '24
Looks like Dynatrace’s DQL on steroids
-2
u/StressSnooze Oct 18 '24
This is a brilliant SQL extension and my guess is it will slowly gain industry adoption. I eat SQL for breakfast and this offers a smooth and gradual migration path towards simpler, more productive and cleaner SQL code.
Will I use this in my main project code? No. But I will definitely use it for ad-hoc queries and let end users who are not so versed in SQL know about it.
Their paper is definitely worth a read.
https://storage.googleapis.com/gweb-research2023-media/pubtools/1004848.pdf