Query Engine: SQL connector must use chunking when a large number of parameters is reached

[mavilein]

Our queries make excessive use of parameters when resolving related records. The databases have different limits for the number of parameters than can be used within a query. We should address this to not fail when retrieving a large number of records.

Tasks:

• Research how many parameters are accepted for each database.
• Within the SQL connector use chunking when that limit is execeeded. Maybe the connection function find_many is the only one that is affected.

[dpetrick]

Possible alternative: Inline values instead of using parameters. No idea how feasible that is.

[pimeys]

Solved and merged in #575