Partial Index Friendly Subscription Scan

Return active subscriptions expiring in next 7 days with id, user_id, expires_at. Assume table has many cancelled rows.

subscriptions(id, user_id, status, expires_at)