Window functions were an addition, but more recently struct, json, and array fields with native support. Pipe syntax is getting multiple implementations.
Match recognize is a whole new standard abstraction of window functions.
Union by name is being added (fuck union by position).
It has though
Window functions were an addition, but more recently struct, json, and array fields with native support. Pipe syntax is getting multiple implementations.
Match recognize is a whole new standard abstraction of window functions.
Union by name is being added (fuck union by position).
Isn’t this more like evolution or even just optimisation? I mean it doesn’t seem like a fundamental shift (can be wrong, just checked it out quickly).
Sure, i think its just sql has not had any breaking version changes in like… ever?
Yeah, that’s really one in a kind for such an important feature.