All Sonar findings in new code addressed: refactors/cleanup, targeted suppressions, case‑insensitive function parsing + backtick escape fix, numeric literals for substring, safe generics for Elasticsearch projections, and cleanup/constants in MongoDB mapper.