If you work with a lot of big JSON files, look into duckdb.  The ability to treat JSON files as database tables and run queries on them has been a game changer for me.