Skip to main content

​
v0.1 — 2026-03-11 — Initial Public Release

DynamoSQL is now publicly available. API
  • POST /v1/query endpoint with execute and plan modes
  • Stateless offset pagination via maxRows / resumeIdx options
  • Row and object response formats via options.responseType
  • x-request-id response header on all Lambda responses for support tracing
Authentication
  • Cognito JWT authentication using the OAuth 2.0 client credentials grant
  • Scoped access: query:execute and query:plan
  • Multi-tenant request scoping via per-tenant IAM role assumption with ExternalId
SQL Support
  • SELECT with column aliases, SELECT *, table.*, SELECT DISTINCT
  • ORDER BY (ascending), LIMIT, OFFSET, FETCH FIRST n ROWS ONLY
  • INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN
  • WHERE with comparisons, BETWEEN, IN, EXISTS, LIKE, IS NULL
  • GROUP BY, HAVING, aggregate functions (COUNT, SUM, AVG, MIN, MAX, STDDEV)
  • WITH CTEs (single and multiple), scalar subqueries, correlated subqueries, derived tables
  • UNION and UNION ALL
  • Arithmetic, bitwise, string operators; CASE, COALESCE, NULLIF
  • Built-in numeric, string, and conditional functions
Docs