The Data Explorer has a different query interface for different APIs. The Table API doesn’t let you enter a query directly, but you can build it in the UI and then see the actual query text.
CosmosDB supports the other querying options you could use with Table Storage too, so when you migrate an app you should be able to keep all your tools the same.
Need more? Here’s the solution.