Comment by pajeets
1 year ago
Yes, having |> isn't breaking SQL but rather enhancing it.
I really like this idea of piping SQL queries rather than trying to create the perfect syntax from the get go.
+1 for readability too.
1 year ago
Yes, having |> isn't breaking SQL but rather enhancing it.
I really like this idea of piping SQL queries rather than trying to create the perfect syntax from the get go.
+1 for readability too.
Honestly, it seems like a band-aid on legacy query language.
SQL a legacy query language?
In order for a thing to be considered legacy, there needs to be a widespread successor available.
SQL might have been invented in the 70s but it's still going strong as no real alternative has been widely adopted so far - I'd wager that you will find SQL at most software companies today.
Calling it legacy is not realistic IMO.
I mean kinda? It's legacy in the "we would never invent this as the solution to the problem domain that's today asked of it."
We would invent the underlying engines for sure but not the language on top of it. It doesn't map at all to how it's actually used by programmers. SQL is the JS to WebAssembly, being able to write the query plan directly via whatever language or mechanism you prefer would be goated.
It has to be my biggest pain point dealing with SQL, having to hint to the optimizer or write meta-SQL to get it to generate the query plan I already know I want dammit! is unbelievably frustrating.
5 replies →