Re:Is BI dead? – On dismantling data's ship of Theseus
by perl4ever on Tuesday September 21, 2021 @06:50PM
(#28611009)
>their weird proprietary query builder
If you're talking about Power Query, the best way to use it is to write code directly once you observe what the interface generates. It's a rather nice kind-of-functional language that really comes into its own when you start using/creating higher order functions.
Power Query gave me an intense craving for a form of SQL with a similar facility for functions.
For example, I have a lot of experience writing Oracle SQL, and Power Query didn't offer "grouping sets". But I realized it could be implemented using functions. It would be so great if SQL supported that.
If you're talking about Power Query, the best way to use it is to write code directly once you observe what the interface generates. It's a rather nice kind-of-functional language that really comes into its own when you start using/creating higher order functions.
Power Query gave me an intense craving for a form of SQL with a similar facility for functions.
For example, I have a lot of experience writing Oracle SQL, and Power Query didn't offer "grouping sets". But I realized it could be implemented using functions. It would be so great if SQL supported that.