Azure Cosmos DB for NoSQL supports a SQL-like query language to retrieve and manipulate JSON documents. You can run these queries in the Azure Portal Data Explorer, SDKs, or REST API.

Example – Retrieve all fields for a specific document:

This returns the complete JSON document where the id matches "WakefieldFamily".

Filtering and Projection You can filter documents using WHERE and return only specific fields:

This uses a JOIN to iterate over the children array and returns only their givenName values.

String Matching Cosmos DB SQL supports functions like CONTAINS, STARTSWITH, and ENDSWITH for text search:

For case-insensitive search, wrap both sides with UPPER().

Null and Missing Property Handling Use IS_NULL() to check for null values and IS_DEFINED() to check if a property exists: