Query Inside Loop (ARCH8064)

Key kotlin.orm.query-inside-loop · Severity warning · Category orm

Flags ad-hoc queries (jdbcTemplate.query, entityManager.createQuery, execSQL) issued inside a loop body - broader than the repository N+1 rule.

Incorrect

for (id in ids) jdbc.queryForObject(sql, id)

Correct

jdbc.query(sqlWithIn, ids)

Fix

Batch the query (IN clause, a join) before the loop.