Limit the number of values allowable an `IN` clause in database queries

Summary

For DB queries, find a way to limit the number of ID lists used in an IN clause as having ~100k of them is definitely an issue. It should be limited to ~1000.

Impact

It was attributed to the root cause from gitlab-com/gl-infra/production#17168 (closed).