This message was deleted.

TIL that named window functions are a thing in SQL. I wonder if I will ever know SQL fully or if it is like a fractal of complexity where the more you know the more you know you don't know.

Truly your words are deep and correct.

Vadim, you are not that far off from knowing everything SQL ... 😉 ... I think it's mostly a matter of which database "camp" you grew up in. As an Oracle and SQL Server veteran I was exposed to a lot of these fancy SQL features (and had to work around them before that). Here are a handful of the newer, more interesting features I think are worth knowing about (and maybe consider implementing in Druid someday): • GROUPING SETS ... looks like Druid already has this • STRING_SPLIT(), STRING_AGG() (SQL Server) • CONNECT BY (Oracle, hierarchal tree walking) • INTERSECT, MINUS (to complement UNION) And one other that I don't know if anyone has implemented explicitly ... • The ability to generate a sequence list as an inline table or CTE Thanks. John