kvstreamer: support pipelining of Enqueue and GetResults calls

[yuzefovich]

Currently, the contract of the streamer is such that the caller must fully exhaust all results produced for a single batch of enqueued requests. We should lift that restriction which will allow us to making the usage of the streamer even more "streaming" in its nature - the caller would continuously enqueue new requests, and the streamer would decide when to send BatchRequests (when they get large enough). This should give us nice performance improvements.

Jira issue: CRDB-16231

[github-actions]

We have marked this issue as stale because it has been inactive for
18 months. If this issue is still relevant, removing the stale label
or adding a comment will keep it active. Otherwise, we'll close it in
10 days to keep the issue queue tidy. Thank you for your contribution
to CockroachDB!