REGR: SpooledTemporaryFile support in read_csv
- [ ] closes #43439
- [ ] tests added / passed
- [ ] Ensure all linting tests pass, see [here](https://pandas.pydata.org/pandas-docs/dev/development/contributing.html#code-standards) for how to run them
- [ ] whatsnew entry


Probably should throw a warning, if we cannot wrap the handle with `io.TextIOWrapper`.

To avoid the try-except, we could check whether the handle has the `readable` attribute, but there might be other attribute errors that might occur inside `TextIOWrapper`.