This release includes a new backend for Shillelagh based on Multicorn2, a foreign data wrapper (FDW) extension for Postgres 13-15. To check it out, run the container:
docker compose -f postgres/docker-compose.yml up
And then the Python script:
from sqlalchemy import create_engine, text
engine = create_engine("shillelagh+multicorn2://shillelagh:shillelagh123@localhost:5432/shillelagh")
connection = engine.connect()
sql = 'SELECT * FROM "https://docs.google.com/spreadsheets/d/1LcWZMsdCl92g7nA-D6qGRqg1T5TiHyuKJUY1u9XAnsk/edit#gid=0"'
for row in connection.execute(text(sql)):
print(row)
It also adds support for Python 3.12, but drops for 3.8. It should be possible to run in 3.8, but it would require separate dependency files for CI/CD, and since 3.8 reached its end-of-life I decided to drop it as well.