> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dynamosql.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 2026 Changelog

> DynamoSQL release history for 2026.

## 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**

* Interactive API playground and full documentation at [docs.dynamosql.com](https://docs.dynamosql.com)