This library is badly abandoned. I've been looking for a better alternative, but ended up writing my own relatively simple and somewhat inefficient code.

There's some serious potential in combining Pandas and DuckDB[1], which has an ability to efficiently transfer query results into DataFrames.

[1] https://duckdb.org/docs/api/python