One of the things that brought me to Kodi was (in addition to MusicBrainz integration) that it has “smart playlists”—where you give it some criteria (e.g., “genre should be ‘folk’ AND from between 1990 and 2002 AND have ‘June’ in the title”) and then it’ll make a “playlist” based on that. (So essentially saving a query against your music library.)
beets provides this to some extent, but it’d be nice to also have a less resource hungry alternative to Kodi to play music with that also didn’t rely on beets’ pre‐generated playlists.
I looked at Banshee a bit (I think I used that ages ago for a bit too), but it looks like that project is essentially dead (no new release in 5 years).
What other options are there?
PS. Obviously, being able to submit listens to ListenBrainz is also a requirement.
Quod Libet comes to mind. I haven’t really used it for quite a while, but I always liked how you can build playlists based on queries, it should be able to do what you described.
I know some folks have been successful using MusicBee under Wine. I don’t know if that’s an option for you. Steven hasn’t added Listenbrainz support yet, but with recent last.fm shenanigans I think he’s leaning that way. I’ll probably make a general post here when he does.