The Kusto service can interpret and run T-SQL queries with some language limitations. While the Kusto query language is the preferred language for Kusto, such support is useful for existing tool that cannot be easily converted to use the preferred query language, and for casual use of Kusto by people familiar with SQL.

Note that Kusto does not support any DDL command in this manner, only T-SQL SELECT statements are supported. See this topic for details on the main differences between SQL Server and Kusto with regards to T-SQL.

Querying Kusto from Kusto.Explorer with T-SQL

The Kusto.Explorer tool supports sending T-SQL queries to Kusto. In order to instruct Kusto.Explorer to execute a query in this mode, prepend the query 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. This can be used, for example, by people familiar with SQL who want to understand the Kusto query language better. To get back the equivalent Kusto query language to some T-SQL SELECT statement, simply add EXPLAIN before the query.

For example, the following T-SQL query:

select top(10) *
from StormEvents
order by DamageProperty desc

Produces this output:

| sort by DamageProperty desc nulls first
| take 10