4 ms·
You're probably getting downvoted just because of Azure, but you are right. ADX/Kusto and KQL is an extremely powerful query language that answers exactly what
by Delphiza 3y ago
You're probably getting downvoted just because of Azure, but you are right. ADX/Kusto and KQL is an extremely powerful query language that answers exactly what OP questions about SQL.
Here's an example of a KQL query that I have in my browser...
Things
| where DeviceTags has "Installed"
| order by LastHeardFromTimeStamp desc
| take 10
KQL also takes ideas from R's Tidyverse and magrittr package. It takes datasets and pipes them into a new function. Like this...
car_data <-
mtcars %>%
subset(hp > 100)
From the Microsoft auto downvoters out there, all Azure dashboards and infrastructure analytics run on KQL (think Graphana, but on Azure). There are billions of KQL queries executing continuously, so it is absolutely a good example of a non-SQL query language that is active and mature.
- pjmlp 3y agoI don't care, at least on Azure there are real people to talk to, when support is needed. :)