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).

[–] Valmond@lemmy.world 1 points 1 month ago (1 children)

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).

[–] panda_abyss@lemmy.ca 2 points 1 month ago (1 children)

Sure, i think its just sql has not had any breaking version changes in like… ever?

[–] Valmond@lemmy.world 2 points 1 month ago

Yeah, that's really one in a kind for such an important feature.