Backend Queries

Parameterized database queries prevent SQL injection by enforcing safe query patterns that separate code from user input. This skill guides you in structuring data retrieval and filtering to ensure all backend queries are secure across SQL and ORM layers.

Fixing N+1 query issues in an ORM requires applying eager loading strategies to fetch related data in fewer trips. This skill helps you optimize performance through selective column retrieval and proper join construction to eliminate redundant database calls.

Handling transactions for related database operations ensures consistent data state and transactional integrity. This skill directs you in wrapping complex query construction and related data modifications within proper transaction boundaries to prevent partial updates.

Database indexing for backend query optimization is needed when filtering and sorting operations cause performance bottlenecks. This skill identifies appropriate indexing strategies to accelerate data retrieval and enforce high-performance query execution patterns.

This approach works for both raw SQL and ORM query builders by applying universal performance and security principles. The skill enforces parameterization, proper indexing, and safe query patterns across diverse data access layers to prevent injection and performance issues.

Backend queries have performance issues despite correct indexing when lacking selective column retrieval or using inefficient joins. This skill addresses performance optimization comprehensively, evaluating eager loading strategies and complex query construction to resolve bottlenecks.