One cool feature of duckdb is that you can directly run sql against a pandas dataframe/arrow table.[1] The seamless integration is amazing.

[1]: https://duckdb.org/docs/api/python/overview.html#dataframes