How can I include spaces in column names in cosmos db? When I run this in Cosmos DB Studio:
SELECT c.Discriminator as "name with spaces" FROM c
I get this error: Microsoft.Azure.Cosmos.Query.Core.Exceptions.ExpectedQueryPartitionProviderException: {"errors":[{"severity":"Error","location":{"start":26,"end":44},"code":"SC1001","message":"Syntax error, incorrect syntax near '\"name with spaces\"'."}]
The syntax ["..."] works when querying (as mentioned here), but not in the context from the example above.