According to Azure documentation Cosmos DB is a document database (non relational) and at the same time it supoprts SQL, how is that possible ?
<<The Azure Cosmos DB API for NoSQL stores data in document format. It offers the best end-to-end experience as we have full control over the interface, service, and the SDK client libraries. Any new feature that is rolled out to Azure Cosmos DB is first available on API for NoSQL accounts. NoSQL accounts provide support for querying items using the Structured Query Language (SQL) syntax, one of the most familiar and popular query languages to query JSON objects
Azure Cosmos DB is like a big, flexible storage box where you can keep all sorts of things (data) without worrying about organizing them too strictly. It's part of the NoSQL family because you don't have to follow rigid rules on how you store your stuff.
Now, even though it's super flexible, Cosmos DB also lets you use something called SQL to find and work with your data. SQL is a popular tool many people know from the world of more organized databases, where everything has to be in a certain place.
So, how does it do both? Cosmos DB uses a special version of SQL made just for it. This special SQL lets you search through your flexible, mixed up data easily even if it's not organized in a strict way. It's like being able to ask specific questions (using SQL) to quickly find what you need in your big, flexible storage box (Cosmos DB).