This is an interesting one, with probably some conflicting opinions on:
While entering a new album, I encountered some tracks having two guitar players.
One credited as playing ‘solo guitar’, the other one as playing ‘rhythm guitar’.
While they may theoretically both be playing the exact same type and model instrument, their role is certainly different.
Yet you can not select either ‘solo guitar’ or ‘rhythm guitar’. Only ‘guitar’.
I feel that that should be an option though. It is rather relevant and helpful information for knowing who is playing what on a certain recording.
A comparison with classical music: a tenor and a baritone both use vocal chords as their instrument, but also have different roles.
You can note this distinction in the “instrument credit” field. If ever we decide we want to make specific “rhythm guitar” and “solo guitar” etc. instruments, they’re easy to find, and until then, their role is still documented.
I’ve come to the opinion that SQL is the worst way to search a database. What we end up with is having to query is a bunch of highly-optimized storage structures instead of the more natural organization that the web interface provides.