stream: alternative async generator transform
Adds an alternative and more unified async generator support to pipeline. The "old" async function*(source)
syntax is still supported but should be considered legacy after this.
I believe this removes the need for #39067.