T-SQL support
Kusto query language (KQL) is the preferred query language.
T-SQL support, however, is useful for tools that can't be easily converted to use KQL.
T-SQL support is also useful for casual use by people familiar with SQL.
Kusto can interpret and run T-SQL queries with some language limitations.
Note
Kusto doesn't support DDL commands. Only T-SQL select statements are supported.
For more information about the main differences with regards to T-SQL,
see SQL known issues.
Querying from Kusto.Explorer with T-SQL
The Kusto.Explorer tool supports T-SQL queries to Kusto.
To instruct Kusto.Explorer to execute a query, begin the query with an empty T-SQL comment line (--).
For example:
--
select * from StormEvents
From T-SQL to Kusto query language
Kusto supports translating T-SQL queries to Kusto query language (KQL).
This translation can help people familiar with SQL to better understand KQL.
To get back the equivalent KQL from some T-SQL select statement, add explain before the query.
For example, the following T-SQL query:
--
explain
select top(10) *
from StormEvents
order by DamageProperty desc
produces this output:
StormEvents
| sort by DamageProperty desc nulls first
| take 10