I released a new tool for running SQL joins against data from CSV and JSON files: https://simonwillison.net/2021/Jun/19/sqlite-utils-memory/

Demo video: https://www.youtube.com/watch?v=OUjd0rkc678