To execute this query we probably will have the following steps:
User sends a request with this string.
Your Compute-applications receives it.
You parse this string to Object structure (it is basically you current task, but you don't work with such queries at the moment)
Object structure is converted to SQL (e.g. CREATE TABLE MyLogs ( Level text, Timestamp datetime, ...).
The SQL query is executed on SQLite table.
How to convert Kusto types to SQlite types. For example, Kusto has string type. Does Sqlite have string type? If yes, can we use it? If no, what type should we use on SQL level. And the same for every Kusto type.
Things to consider:
Do we need to create some additional tables, or columns. Maybe you need to store some metadata for given user, or for given table. Let's investigate, what metadata do we need, and how to store it in Sqlite.
The result of given task is we understand what SQL query for Create table we want to receive, when we will convert Kusto create table to SQl create table.
Kusto has tables. Kusto tables, and SQL tables are pretty much the same, in general. https://learn.microsoft.com/en-us/azure/data-explorer/kusto/management/create-table-command
Eventually, we need to support such queries from an User:
To execute this query we probably will have the following steps:
How to convert Kusto types to SQlite types. For example, Kusto has string type. Does Sqlite have string type? If yes, can we use it? If no, what type should we use on SQL level. And the same for every Kusto type.
Things to consider:
Do we need to create some additional tables, or columns. Maybe you need to store some metadata for given user, or for given table. Let's investigate, what metadata do we need, and how to store it in Sqlite.
The result of given task is we understand what SQL query for Create table we want to receive, when we will convert Kusto create table to SQl create table.