Push Filters Down, Not Up: The Data Layer Design Principle Most Developers Learn Too Late

Overview One of the most pervasive and costly performance anti-patterns in back-end development is unbounded data fetching — querying the database for an entire result set when only a fraction of that data is needed by the caller. This pattern is deceptively simple to introduce, difficult to detect in development environments with limited data, and expensive in production systems operating at scale. This article examines where unbounded fetching occurs, why it degrades performance across the full request lifecycle, and how to eliminate it at each layer of the stack — from SQL queries to ORM abstractions to API contract design.