zlacker

[return to "Google's new pipe syntax in SQL"]
1. summer+hO9[view] [source] 2024-08-28 22:00:30
>>heyden+(OP)
Previous submissions on the paper itself:

>>41321876 (first) >>41338877 (plenty of discussions)

I tried this new syntax and this seems a reasonable proposal for complex analytical queries. This new syntax probably does not change most simple transactional queries though. The syntax matches the execution semantic more closely, which means you less likely need to formulate query in a weird form to make query planner work as expected; usually users only need to move some pipe operators to more appropriate places.

◧◩
2. Fridge+LU9[view] [source] 2024-08-28 22:52:20
>>summer+hO9
Kinda looks like a half-assed version of what PRQL does. Like, if we’re going to have nonstandard sql, let’s just fix a whole bunch of things, not just one or two?
◧◩◪
3. hn_thr+7pa[view] [source] 2024-08-29 04:04:19
>>Fridge+LU9
> Kinda looks like a half-assed version of what PRQL does. Like, if we’re going to have nonstandard sql, let’s just fix a whole bunch of things, not just one or two?

To be honest, this feels exactly like the kind of mistake that IPv6 made. It wasn't just "let's extend the IPv4 address space and provide an upgrade path that's as incremental as possible", it was "IPv4 has all these problems, lets solve the address space issue with a completely new address space, and while we're at it lets fix 20 other things!" Meanwhile, over a quarter century later, IPv4 shows no signs of going away any time soon.

I'd much rather have an incremental improvement that solves 90% of my pain points than to reach for some "Let's throw all the old stuff away for this new nirvana!" And I say this as someone that really likes PRQL.

◧◩◪◨
4. andrew+Sza[view] [source] 2024-08-29 06:11:25
>>hn_thr+7pa
You can't "just" extend the IPv4 address space while keeping the compatibility.
◧◩◪◨⬒
5. bvrmn+hNa[view] [source] 2024-08-29 08:45:50
>>andrew+Sza
Extending src/dst in current IPv4 protocol headers is much easier than adopting a completely new suite.
[go to top]