ADX supports very basic transformation of T-SQL to KQL, as it is limited to normal SQL statements.

Currently support for prepared statements doesn’t seem to be in-place. This would greatly improve security of the emulation layer by enabling prepared statements to be used.

This would also allow semantic layers and customer facing analytics tools such as Vizzly to integrate in a secured manner.

​ADX supports very basic transformation of T-SQL to KQL, as it is limited to normal SQL statements.Currently support for prepared statements doesn’t seem to be in-place. This would greatly improve security of the emulation layer by enabling prepared statements to be used. This would also allow semantic layers and customer facing analytics tools such as Vizzly to integrate in a secured manner.   Read More

​