Agreed... Their SQL is awesome and seemingly only getting better. My favorite is window aliases (I'm sure it's found in other SQL engines too). It's not only c

Agreed... Their SQL is awesome and seemingly only getting better. My favorite is window aliases (I'm sure it's found in other SQL engines too). It's not only cleaner and less likely to accidentally introduce a discrepancy, but apparently also results in better performance. > The three window functions will also share the data layout, which will improve performance. https://duckdb.org/docs/sql/window_functions#window-clauses https://duckdb.org/docs/sql/window_functions#window-clauses I'm surprised some of the other big-name OLAPs don't provide this. *cough* Snowflake *cough*. Snowflake's query optimizer doesn't even seem to recognize common window definitions across multiple window functions.