Support multiple_members on compression decoders? #9156

Is your feature request related to a problem or challenge?

The challenge is that currently when trying to use the gzip decoder from async-compression to decode block-gzipped files, the query ends after the first block in the file not the EOF.

Based on an issue filed here: Nullus157/async-compression#260, bgzip works if the decoder is modified to support multiple members (I've confirmed this is the case).

Describe the solution you'd like

So my feature request is the ability to specify to call this method or have it set by default (though I'm not sure the performance implications).

I'd be happy to take a look a this, but I'm not sure what an appropriate path would be that's congruent with datafusion overall.

Describe alternatives you've considered

No response

Additional context

No response