Deferred Execution Patterns

Minimize database roundtrips by understanding when queries are materialized.