>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 interfac

>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.