Re:We Can Do Better Than SQL (2019)
by perl4ever on Saturday August 08, 2020 @11:34PM
(#24097042)
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.
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.