3 ms·
We're currently trying out QueryStorm [1]. It supports SQL through built in SQLite, but you can connect to any DB and get the full SQL feature set of your DB. I
by lowkeyokay 9y ago
We're currently trying out QueryStorm [1]. It supports SQL through built in SQLite, but you can connect to any DB and get the full SQL feature set of your DB. It's also possible to manipulate data, and automate stuff using C#. So far it's been quite good. Everyone can view spreadsheets created using QueryStorm, but the data will just be plain data unless they have QueryStorm installed. That's the only drawback.
I really thought PowerPivot could be this excellent data tool, but the DAX formula language is just such a pain. I really dislike it. Using SQL og C# is just much more intuitive - especially SQL.
1: https://querystorm.com https://querystorm.com