[rwhaling]

Really cool - the stuff they are doing with the Excel API to inspect editing modes is super interesting: https://www.sharpcells.com/docs/blog/monitoring-edit-mode

I work with data warehouses, but I'm really jealous of the way our Finance team uses some abysmal plugin to directly query our GL from inside Excel - building something like that the can make the contents of a modern data warehouse available to Excel users has always been a holy grail for me.

My hunch is that exposing free-form SQL in Excel doesn't work, but something more like structured metrics (something roughly like dbt metrics) could potentially work? And tooling like this is probably what I'd want to prototype with.

[inglor]

You can both feed SQL data sources into Excel and expose Excel as an ODBC data source (natively, usable today and used by a lot of companies!)

[matt3D]

I think PowerQuery largely solves this problem

[listenallyall]

Can't be that abysmal if you're jealous of it and is similar to your idea of a holy grail. Is it Jedox perhaps?