Forum Discussion
T-SQL executing directly in Eventhouse KQL Queryset without comment (--) prefix
Thank you, @ svelde for your response.
Hi Ruchi23,
We appreciate your inquiry through the Microsoft Fabric Community Forum and thank you for validating the behavior across both Fabric Eventhouse and Azure Data Explorer.
Based on my understanding, the observed behavior may be due to the query editor's language auto-detection. Modern Fabric and ADX web query editors may automatically recognize T‑SQL syntax and route the query to the T‑SQL engine even without the -- prefix. This could be an editor convenience feature, and does not represent a change to the underlying Kusto or T‑SQL language requirements.
Official Microsoft documentation continues to recommend starting T‑SQL queries with a standalone -- because it explicitly forces T‑SQL mode and avoids ambiguity. It also ensures consistent behaviour across automation, APIs, scripts and non‑UI tools. Moreover, certain advanced or mixed syntax scenarios still rely on explicit mode selection.
We hope the information above helps to resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.
Thank you.
Super UserHello Ruchi23,
Welcome to this community forum.
Good catch, I also experience that my SQL queries work will without the '--' on a separate in from of the query, when I use the Fabric portal KQL Queryset editor.
That said, it can be that other editors for eg. Azure Data Explorer or Microsoft Sentinel still need that extra line. I'm not able to test this.
--
If this answer helps, please upvote it. Thanks.
Thanks for confirming!
I actually tested this on Azure Data Explorer as well and got the same result, T-SQL queries work there too without the "--" prefix.
Looks like the query editors are just smart enough to figure it out now. I wonder if the docs are just outdated at this point or if there's some specific case where you still need it that we just haven't run into yet.