Data access models

Probably the most important option to select before creating the Cosmos DB instance is the access model (that is, the API). In our application, we will be using the SQL API since it is inherently the only native access model and allows the usage of additional features such as triggers. Nevertheless, let's take a quick look at the other options that are available.

SQL API

Previously a standalone offer known as Azure Document DB, the SQL API allows developers to query a JSON-based NoSQL data structure with a SQL dialect. Similar to actual SQL implementations, the SQL API supports the use of stored procedures, triggers (that is, change feeds), and user-defined functions. Support for SQL queries allows...