I am learning Power Query. It's the first Microsoft technology in quite a while that's left a positive first impression. I'm not particularly crazy about relea

I am learning Power Query. It's the first Microsoft technology in quite a while that's left a positive first impression. I'm not particularly crazy about relearning how to do the things I would do in SQL, differently. On the other hand, I feel like some of the straightforward functional language features would be helpful to have in SQL. I always felt like T-SQL and especially PL/SQL were terrible mistakes, but that SQL was missing something. Power Query didn't seem to have something like GROUPING SETS, but I was very pleased when it seemed natural to roll my own as a function. SQL (at least the dialects I'm used to) doesn't lend itself to that sort of thing.