molecular data meta endpoint needs to handle multiple molecular profiles #11761
Description
We need the ability to retrieve counts for multiple molecular profiles (data) with a single call/query. It shoudl replace this foreach here:
Note that currently we use the Meta endpoint, which returns counts in the http header.
The problem is that we have multiple hits to the database which forces Clickhouse to do the joins multiple times.