How should Repository pattern be applied in a production system?

Expose intent-based methods, keep query ownership clear, avoid leaking persistence details, and use the pattern only when it adds a useful boundary.