Load extension in Python API

[freddie-freeloader]

We might need to build the Python library ourselves, to load our unsigned extension:

https://github.com/duckdb/duckdb/tree/main/tools/pythonpkg

• Loading unsigned extensions in Python library: https://duckdb.org/docs/api/python/overview#loading-and-installing-extensions

  To load unsigned extensions, use the config = {"allow_unsigned_extensions": "true"} argument to the duckdb.connect() method.

con = duckdb.connect(':memory:', config={'allow_unsigned_extensions' : 'true'}) con.install_extension("../build/release/extension/sheetreader/sheetreader.duckdb_extension") con.load_extension("sheetreader")

[freddie-freeloader]

We found a workaround for the metadata mismatch: #15