Resolve "SQL performance: large list of values as subquery expression"

Description

Provide long lists as subquery expression instead:

IN(SELECT(UNNEST(array)))

When loading an analysis in ella, this gives about 10% speed improvement.

Related issues

Notes to review (code/docs/QA)

Tests

General

• Tests have been added that prove my fix is effective or that my feature works
• Related tests have been modified/removed

Hypothesis testing:

• Soak testing has been done
• Distribution between positive / negative cases has been checked

Database

• Includes changes to database schema
• Includes necessary database migrations

Configuration

• Includes changes to configuration
• Includes configuration migration instructions in documentation

Closes #1979 (closed)