ANSI SQL for Amazon DynamoDB • Optimized execution • No
ingestion
Run real SQL on DynamoDB.
DynamoSQL™ is a high‑performance SQL query engine optimized for Amazon DynamoDB. Execute complex SELECT queries—joins, CTEs, aggregations, and more—directly on customer-owned tables.
WITH recent_orders AS (
SELECT o.customer_id, o.total, o.order_date
FROM Orders o
WHERE o.order_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;