Migration from duckdb_engine
This project is the actively maintained DuckDB SQLAlchemy dialect. If you are coming from the older duckdb_engine package, migrate as follows:
Package and import rename
Install the new package:
pip install duckdb-sqlalchemy
Update imports:
from duckdb_sqlalchemy import Dialect, URL, MotherDuckURL
SQLAlchemy URLs use the duckdb:// driver name in both packages. Existing URLs will continue to work.
Notes
- The package name is now
duckdb-sqlalchemyand the module isduckdb_sqlalchemy. - The dialect remains registered as
duckdbfor SQLAlchemy. - See
docs/motherduck.mdfor MotherDuck-specific behavior.