use DuckDB instead sqlite

[seufagner]

This project seems fastly and uses most modern approach

https://www.duckdb.org/docs/current/python/api.html

https://www.youtube.com/watch?v=PFUZlNQIndo

[stonebig]

Select sum(1) from lineitem gives -2 on your live demo

[danielvanacker]

MonetDBLite is generally faster than DuckDB and supports are a larger set of SQL syntax thus could also be an option if this is ever considered.

[Alex-Monahan]

The DuckDB Python API completely replaces PandaSQL in my opinion! You can convert multiple data frames into DuckDB views and query them without even inserting them first! It's incredibly fast, and just as user friendly as this library.
DuckDB Python API Examples