I'm building an application where the users will be sufficiently advanced and will need to have the ability to build complex queries for reporting. The backend is an Azure SQL Instance and we're using dotnet/EF core. I obviously don't want the users being able to run arbitrary SQL against the database so I'm looking for something that would allow users to make read-only queries that can join certain tables together.

​

I learned about the Kusto query language at Ignite for log analytics, but I was wondering if this language could be used against a standard MS SQL database or perhaps against an in-memory dataset. The deeper I dig, the more it looks like it only works against specific MS databases (It looks like there is a Kusto database now).

​

What I'm looking for is something like EasyQuery (https://korzh.com/easyquery) which I have no problem paying for, however it looks like it is simply building out SQL for the end user, which could likely be abused.