Debug: Non-Sargable Filter in CTE

Fix for index usage. WITH filtered AS (SELECT * FROM orders WHERE DATE(order_date) = '2026-05-01') SELECT customer_id, COUNT(*) FROM filtered GROUP BY customer_id;

orders(order_date, customer_id)