That's something similar to DynamoDB and CosmosDB. I believe the workaround is to have paging on client side to fetch all results.