Migrating Applications to the Cloud with Azure

The SQL API

Cosmos DB provides a SQL layer over a document database. The data is stored in collections as JSON, just like they are with MongoDB. However, retrieving that data can be done using SQL queries instead of MongoDB JavaScript objects. That being said, SQL is not entirely what you're used to. While most of it looks the same, some operators, such as LIKE, are not supported. Because we're still dealing with a schemaless JSON database, other functions have been introduced. For example, STARTSWITH, ENDSWITH, and CONTAINS make up for the lack of the LIKE operator, while IS_DEFINED checks whether a property has been defined on a document:

All your documents can be queried through an HTTP-based RESTful API. For example, to get a document, ...