IoT Hub supports a SQL-like language to retrieve information regarding device twins, jobs, and message routing. Basically, you can write a basic SQL command and that will be executed against the device registry.

Each query follows the syntax like SQL; it has the standard SELECT, FROM, and WHERE keywords used to retrieve the result set in the result window.