CosmosDB: Allow running queries without Partition Key

[KStillings-Slalom]

Feature Request
In PR #17657, support was added for running an CosmosDB SQL query against a single partition in CosmosDB. However, in the Data Explorer UI and in other SDKs, a query can be run without specifying a partition key, and run across the entire container.

Could this functionality be added for feature parity with the other SDKs 🙏

Thanks!

I've seen issues raised for this function, but there's not been any traction. Is this something that will be addressed?

Related issues:
#20393
#18578

Seems both issues just sat for a few months and were automatically closed without being implemented. Is this in the works?

[mbarnes]

The conversation is locked in #18578 so adding a thought here.

Rather than blocking on an all-or-nothing solution to cross-partition queries, it seems like you could cover a lot of simple use cases by adding a method like

func (*ContainerClient) ReadAllItems(ctx context.Context, o *ItemOptions) *runtime.Pager[QueryItemsResponse]

which returns unordered results (at least initially) and letting clients deal with filtering and ordering.

I understand from the other issue there would still be significant complexity behind this -- fetching the partition map and orchestrating SELECT * queries across partitions -- but it would still be a significant enhancement to the SDK while working toward a general solution.