Full support for fsspec urlpaths is broken due to rioxarray / rasterio not accepting a file-like object

[alexamici]

Until some releases ago we had full fsspec thanks to the following line working:

ds = xr.open_dataset(fs.open(urlpath), engine="rasterio")

This broke with some recent release of rioxarray or xarray, I think due to the fact that the open file is assumed to be a simple python object not a fsspec one.

At the moment a workaround is in place that attempt to use rasaterio remote URLs, but it is very fragile.