Emulator "per-query JOIN" limit is 5, but the live service supports 10

[DrEsteban]

As published on official docs, and confirmed by our usage of CosmosDB, the per-query limit for JOINs is 10: https://learn.microsoft.com/en-us/azure/cosmos-db/concepts-limits#sql-query-limits

However, the emulator appears to only support a max of 5 joins per-query:

Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: ; Reason: ({"errors":[{"severity":"Error","location":{"start":0,"end":1371},"code":"SC3002","message":"The SQL query exceeded the maximum number of joins. The allowed limit is 5."}]});

This means we cannot test/emulate our product code locally in this scenario.