This message was deleted.

I've dealt with the APPLY functions briefly before ... I think the equivalent would be a correlated subquery, either in the select list, or as a CTE. Can you provide the (or one example of a) SQL statement with the Apply clause that you would like to translate?

Kusto function mv-apply ==================== Table1 | where True | mv-apply r=col1 on (where r.location in ("INDIA") | summarize new-col1=make_list(r)) | project col1,new-col1,xcol1