Regarding duckdb, I find that I have internalized the workings of SELECT … COUNT(*) GROUP BY 1 so much that I prefer to roll my own processing frameworks off of orjson in pure Python.