CosmosDB is Awesome yet lacks....a few

CosmosDB (SQL API) is awesome. It works great. However, it lacks a few things that are going to released soon as of 7/9/2019

1. Cross collection query - don't know when is this planned.
2. JSON validation - Summer 2019
3. Pre-Insert triggers not exactly how you expect them to work.