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).
Alrighty, everything is finally green!  If people can take a look at and give feedback on this, that would be great so we can get this merged before tomorrow.