Failing to read files using DirFileSystem

[rudyryk]

We get Permission Error: File system LocalFileSystem has been disabled by configuration exception when trying to read via st_read().

Indeed we disable LocalFileSystem but we provide registered dir:// file system which can be normally used by read_csv().

Here's an example to reproduce the issue:

import duckdb
from fsspec import filesystem

duckdb.install_extension('spatial')
duckdb.load_extension('spatial')
duckdb.register_filesystem(filesystem('dir', path='/tmp/'))

# This works
csv_result = duckdb.sql("SELECT * FROM read_csv('dir://test.csv', null_padding = true) LIMIT 2")
print(csv_result)

# This works
xls_result = duckdb.sql("SELECT * FROM st_read('dir://test.xlsx') LIMIT 2")
print(xls_result)

# Disable local file system
duckdb.execute("SET disabled_filesystems = 'LocalFileSystem'")

# This still works
csv_result2 = duckdb.sql("SELECT * FROM read_csv('dir://test.csv', null_padding = true) LIMIT 3")
print(csv_result2)

# This now fails!
xls_result2 = duckdb.sql("SELECT * FROM st_read('dir://test.xlsx') LIMIT 3")
print(xls_result2)