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