With TubeArchivist, all the metadata is stored in an ES database and can be queried via API. There's already a Plex and Jellyfin plugin folks are using.
Quasi-related - what other tech channels are you following? I like LGR quite a bit. Just found The Serial Port - loving that one, building a dial-up ISP.