https://calmcode.io/datasette/introduction.html is a nice introduction to https://datasette.io/
select name, thing from person, thing, person_thing pt where person.id = pt.person_id and thing.id = pt.thing_id;
For this example, there are three text CSV files to start with:
person.csv
id,name
1,Matt
2,Tracey
3,Pascal
4,Poppy
thing.csv
id,thing
1,computers
2,knitting
3,dogging
person_thing.csv
id,person_id,thing_id
1,1,1
2,2,2
3,3,3
4,4,3
Put these in a SQLite database like so:
csvs-to-sqlite person.csv thing.csv person_thing.csv eg.dbdatasette eg.db