You use Azure SQL Database Intelligent Insights and Azure Application Insights for monitoring. You need to write ad-hoc queries against the monitoring data. Which query language should you use?
Data analysis in Azure SQL Analytics is based on Log Analytics language for your custom querying and reporting. References: https://docs.microsoft.com/en-us/azure/azure-monitor/insights/azure-sql