REG: Restore read_csv function for some file-likes
Restore `read_csv` function for some file-likes
    
Restores behavior down to the fact that the Python engine cannot handle NamedTemporaryFile.
    
Closes https://github.com/pandas-dev/pandas/issues/31819
    
Credit to @sasanquaneuf for [originating idea](https://github.com/pandas-dev/pandas/issues/31819#issuecomment-584529415).