[Consult] - KQL For Persistent Storage Sources

[dfirence]

Hi -

Can you provide an example of how KQL could be used as a query layer for persistent storage datasources like Sqlite?

I would like to create an in-process application (foo.exe) that can expose the KQL via VSCode, but route the queries against the persistent store (sqlite) instead of Azure hosted data sources.

[sloutsky]

You would need to translate KQL queries into SQLite queries (not always possible to due fact that some functions are not supported by SQLite engine).
Your application can use this parser to analyze the query-text and produce an object tree - so you can walk it and create a SQL query.
We can't provide you the examples how to achieve this task - as it's much beyond the scope of the KQL parser logic.

[dfirence]

@sloutsky - thanks for the prompt response.

Can I instead use KQL and point its queries against “MySql” or “PgSql”?

or is KQL exclusively reserved for use with an Azure Data Service?