More improvements to the async query pipeline.

This implements IAsyncEnumerable<T> implicitly.