CrateDB gets two major advantages from the NoSQL side. One is support for unstructured data via JSON documents and BLOB storage, with JSON data queryable through SQL as well.

SQL Query Capability - Enables SQL queries on NoSQL Cassandra data. Cassandra 2.x Compatibility - Leverages the faster performance and improved security of Cassandra V2.x.

The vector search in Cosmos DB for NoSQL, according to the company, is powered by DiskANN—a suite of scalable approximate nearest neighbor search algorithms that support real-time changes.