Generally available: Azure Cosmos DB Core (SQL) API Query Engine improvements
Published date: 22 June, 2022
You can now use several new query engine improvements for enhanced query functionality in Azure Cosmos DB SQL API. These query engine improvements include both new features and optimizations to existing query engine features. The most notable new feature is DateTimeBin, a new built-in system function that makes GROUP BY queries with dates even more useful for analyzing data. Other improvements include the ability for GROUP BY, DISTINCT, and OFFSET LIMIT queries to utilize the index for more scenarios. There are also significant automatic optimizations to queries with JOINs without needing to use subqueries.