Backend Queries

Write efficient, secure database queries following best practices for SQL injection prevention, performance optimization, and data fetching strategies. Use this skill when writing database queries, building query logic, or optimizing data retrieval code. Apply when working with SQL query files, ORM query builder code, raw SQL strings, query optimization, database access layers, repository pattern implementations, or any code that retrieves or manipulates data from databases. Use when implementing parameterized queries, eager loading relationships to prevent N+1 queries, selecting specific columns, creating database indexes, implementing query timeouts, using transactions for data consistency, or caching expensive queries. Apply when optimizing database performance, preventing SQL injection vulnerabilities, or refactoring inefficient data access patterns.