Return random for $sample
$sample should return an actual random sample.
Right now it returns the top/first N items. This is preventing us from porting code over the Cosmos DB.
Will review and revert with comment or questions.
Please implement this not just for Mongo but SQL API too. I need the ability to return a random item from the container to show random "highlighted" items on the UI. I should be able to get a random item based on a query I provide (e.g. filtering on certain properties like IsDeleted soft flag in addition to a partition key).