How to most efficiently query a many-to-many relationship in my SQL database
Say I have a database of songs. Every song may have more than one composer, and every composer may have more than one song: that’s a straightforward many-to-many relationship, which I’ve modelled in Sqlite like this: