Introduction to the NoSQL API
Learn the essential expression to query Cosmos DB on NoSQL and the limitations and differences with traditional RDBMS’s SQL.
SQL in a NoSQL database
For those unfamiliar with the terminology, using SQL in a NoSQL database might sound strange. However, NoSQL means Not Only SQL, and even if databases like MongoDB ditched it for a custom query language, Cosmos DB embraces it as its primary query language.
What is it?
The Cosmos DB NoSQL API is the primary way to query the database. It closely represents the underlying document architecture, while other APIs must project it.
Microsoft has complete control over the interface, service, and SDKs, so every new feature is first available on this API.
As said above, the NoSQL API uses SQL syntax, the most popular query language. However, the lack of relationships and the nature of JSON documents make it impossible to support the SQL we might ...