Given the folllowing structure: apps -> releases -> file metadatas

User searches are performed on apps, once an app is selected we fetch latest release, and from there grab file metadatas.

It's easy when the search is done on one event kind (apps) but now I need to also start filtering on file metadatas (for platform/os/architecture). You don't want to be presented search results for which there's no app for your operating system.

Theres no way of doing joins or more expressive querying in nostr - unless copying the data I need onto one single event kind, which is the workaround I did and I hate it.