zlacker

[return to "Pipe Syntax in SQL"]
1. typede+1Y[view] [source] 2024-08-24 23:07:50
>>legran+(OP)
You can tell the authors realized this was a bad idea when they had to add the 'OVER' keyword, which isn't documented and hardly mentioned in the paper.
◧◩
2. roryok+Ue1[view] [source] 2024-08-25 01:49:41
>>typede+1Y
ZetaSQL’s docs for the ‘OVER’ keyword you mention: https://github.com/google/zetasql/blob/master/docs/window-fu...

I disagree that the paper not mentioning ‘OVER’ implies that the paper authors secretly think pipe syntax is a bad idea. They probably just wanted to keep the paper concise, or forgot about that one less-used bit of syntax.

Do you think that ‘OVER’ keyword implies something fundamentally wrong about pipe syntax? If so, how?

[go to top]