I have some Spotify suggestions for you, if you don't know them already.
> all the album by this label
label:[label name] is helpful. There are better options. this one comes to mind https://www.lbl.fm/
> all the songs produced by X
If you open the credits of a track, you will find that some writers (no producers) are hyperlinked to a page where you can listen to all their songs as a playlist.
> all the songs where in Y plays drums. All the albums recorded at some studio in the year
A Hint: try you luck with a search for a known label, producer or even drummer, or studio, and you will be surprised by how people are creative/meticulous with their public playlist’s choices (the human pool is just getting way too large, 400 millions and counting)
Also, you can take a look at https://spicetify.app/. It is a marketplace for extending the desktop app (some data related add-ins in there). it is still very young and hacky but IMO it is the right direction.