search

microsoft / Kusto-Query-Language

Kusto Query Language is a simple and productive language for querying Big Data.
Apache License 2.0
510 stars 97 forks source link

[Consult] - KQL For Persistent Storage Sources #139

Closed dfirence closed 3 months ago

dfirence commented 3 months ago

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 commented 3 months ago

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 commented 3 months ago

@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?