Database Queries

The API uses optimized read-only queries.

Principles

• No SELECT *
• Indexed filters
• Pagination enforced
• Query execution time monitored

Example (Conceptual)

• Customers queried by status
• Results mapped to DTOs