SQLAlchemy in_ queries for gene panels take _very_ long to complete
Background
When using
tuple_(model.genepanel_name, model.genepanel_version).in_(
(gp.name, gp.version) for gp in genepanels
)
the queries can take a very long time, depending on the size of the gene panels (not scaling with number of gene panels).
Implementation
Remove all simple filters like above, and replace with subquery filters.