SQL Reference Overview

DynamoSQL implements a substantial subset of ANSI SQL targeting DynamoDB and CSV backends. The engine is read-only — it supports SELECT queries only. There is no INSERT, UPDATE, DELETE, or DDL.

Supported Feature Categories

Category	Reference
SELECT, double-quoted identifiers, column aliases, DISTINCT, ORDER BY, LIMIT	SELECT
Single tables, JOINs, derived tables, CTEs as sources	FROM and JOINs
Comparisons, BETWEEN, IN, EXISTS, LIKE, IS NULL	WHERE Predicates
GROUP BY, HAVING, GROUPING SETS, ROLLUP, CUBE, aggregates	Grouping and Aggregation
WITH clauses, scalar subqueries, correlated subqueries	Subqueries and CTEs
UNION, UNION ALL, INTERSECT, EXCEPT	Set Operations
Arithmetic, bitwise, string, CASE, COALESCE	Expressions and Operators
ABS, CONCAT, SUBSTRING, IF, UUID, aggregates	Functions

Unsupported features — including window functions, INSERT/UPDATE/DELETE, recursive CTEs, and date/time functions — are listed on the Limitations page.

Quick Example

WITH recent_orders AS (
  SELECT
    o.customer_id,
    o.total,
    o.status,
    c.name AS customer_name
  FROM myschema.orders AS o
  INNER JOIN myschema.customers AS c ON o.customer_id = c.id
  WHERE o.status = 'shipped'
)
SELECT
  customer_name,
  COUNT(*) AS order_count,
  SUM(total) AS total_spent
FROM recent_orders
GROUP BY customer_name
HAVING SUM(total) > 500
ORDER BY total_spent
LIMIT 20

This query demonstrates a CTE, an INNER JOIN, WHERE filtering, GROUP BY with an aggregate, HAVING, ORDER BY, and LIMIT — all supported today.

Get Started

Guides

MCP Server

API Reference

SQL Reference

Changelog

SQL Reference Overview

Supported Feature Categories

Quick Example

​Supported Feature Categories

​Quick Example

Supported Feature Categories

Quick Example