Cool tool!

Panda SQL is great for doing SQL on pandas dataframes. https://pypi.org/project/pandasql/

DuckDB is a newer but much faster alternative that lets you run SQL on csv files (and also directories of parquet files etc.)

It's so fast/good that I've actually been using it for a lot of data cleaning and transformation that previously I'd have done in Pandas.

https://github.com/duckdb/duckdb