Re:One SQL to Rule Them All: Management of Streams and Tables
by michaelmior on Friday May 31, 2019 @08:02AM
(#20060066)
I agree that listing 2 is a little verbose, but once you understand the syntax (not much different from vanilla SQL), it's pretty powerful. I think writing queries this way will ultimately allow for more expressiveness than something more concise. That isn't to say that this particular SQL is necessarily the best, but I think it works well for the problem at hand.
[ Parent
| on HN ]
Re:One SQL to Rule Them All: Management of Streams and Tables
by dwenzek on Saturday June 01, 2019 @04:31AM
(#20068098)
Sure, SQL is powerful and I agree that any alternative would also bring its own complexity. However, my concerns are more about encapsulation rather than expressiveness and conciseness. Even if a watermark is used the same way in different queries, I will have to use the same query clause again and again; as I already have to with the join conditions. Not a fundamental issue, but something which makes me more difficult to focus on the kernel of a query.