Silent Query Failures: The Hidden 1000-Row Limit That Breaks Production

Supabase's PostgREST API silently caps queries at 1000 rows when ORDER BY is omitted, returning incomplete datasets without warning or error. This hidden limitation causes unpredictable bugs in production systems where data consistency depends on complete result sets. ESLint rules can detect and prevent this anti-pattern before it reaches production.