Yes! I tried this exact usecase using sqlite-utils as a python lib. I basically made a python script that open each of the json file and insert it into a sqlit

Yes! I tried this exact usecase using sqlite-utils as a python lib. I basically made a python script that open each of the json file and insert it into a sqlite inmemory db using sqlite-utils insert. Then you have a regular sqlite db (in memory) that you can work it!