REF: in pandas.io.common integerate BytesIOWrapper into IOHandle

[arw2019]

references:

• pyarrow CSV engine basic PR
• REF: move get_filepath_buffer into get_handle #37639 (comment)
• REF: move get_filepath_buffer into get_handle #37639 (comment)
• REF: move get_filepath_buffer into get_handle #37639 (comment)

pyarrow requires BytesIO not StringIO so in #38370 we add a class that returns a binary handle to reader input. This class (BytesIOWrapper) should be integrated into IOHandle to better align with the patterns we use elsewhere for file handles (#37639 is the PR that standardized things)

I originally intended to do this in #38370 but I got a little stuck and since that PR is sizeable already I think it's better to spin it off into a separate follow-on task

[lithomas1]

Going to be taking this one now. The main use case for this would be pyarrow reading text data, so would be CSV and maybe JSON if we want that in the future.