Run real SQL on DynamoDB.

WITH recent_orders AS (
  SELECT o.customer_id, o.total, o.order_date
  FROM Orders o
  WHERE o.order_date >= DATE '2025-01-01'
)
SELECT c.customer_name, SUM(r.total) AS spend
FROM Customers c
JOIN recent_orders r ON r.customer_id = c.customer_id
GROUP BY c.customer_name
ORDER BY spend DESC
LIMIT 25;