Nick Chapsas

Wait a second. I'm pretty sure you cannot have nested select queries in a Cosmos DB SQL query.

This seems to be a new feature. It wasn’t working some months ago and it isn’t documented anywhere. I will probably have to address this.

Yeah your fix wouldn't work in any other scenario. The fix will have to detect all the queries and inject the appropriate strings with recursion.

Ok so I started looking into this. Can you give me a few example nested select queries without the CosmosEntityName where clause and how you want them to be after...

Hello @Crazedpeanut, I’m not really sure about this one. Ideally you shouldn’t be provisioning your collections through Cosmonaut to begin with. Cosmonaut just does the bare minimum so you don’t...

Hey Rob, Those are all solid points. I would like to see a more detailed example of your proposal to potentially add it as an alternative to the existing solution...

I really like this approach. Feel free to clean it up, write tests and create a PR. Make sure it's backwards compatible.

Does the underlying sdk allow multiple spaces??

I would check how the underlying sdk reacts. It would be too tricky to write the regex for that if it’s not supported. I might pull the sql validation out...

Hey @goda, Cosmonaut allows you to provide your own `IDocumentClient` through the `ICosmonautClient` which is required in one of the constructors for the `CosmosStore` so a temporary workaround would be...