Supported SQL for Aurora DSQL

FROM

GROUP BY

ALL, DISTINCT

ORDER BY

ASC, DESC, NULLS

LIMIT

DISTINCT

HAVING

USING

WITH (common table expressions)

INNER JOIN

ON

OUTER JOIN

LEFT, RIGHT, FULL, ON

CROSS JOIN

ON

UNION

ALL

INTERSECT

ALL

EXCEPT

ALL

OVER

RANK (), PARTITION BY

FOR UPDATE

Specify equality predicates on all primary key columns (for example, WHERE pk = value). If you use range, IN, OR, or other non-equality predicates, the query returns ERROR: locking clause such as FOR UPDATE can be applied only on tables with equality predicates on the key.

Specify on a single table query. If you use joins or multiple tables, the query returns ERROR: locking clause such as FOR UPDATE can be applied on a single table.

CREATE

TABLE

For information about the supported syntax of the CREATE TABLE command, see CREATE TABLE.

ALTER

TABLE

For information about the supported syntax of the ALTER TABLE command, see ALTER TABLE.

DROP

TABLE

CREATE

[UNIQUE] INDEX ASYNC

Index keys can be column names or expressions. You can also use INCLUDE, NULLS FIRST, NULLS LAST, and NULLS [NOT] DISTINCT.

See CREATE INDEX for the supported syntax.

DROP

INDEX

CREATE

VIEW

For more information about the supported syntax of the CREATE VIEW command, see CREATE VIEW.

For information about the supported syntax of the ALTER VIEW command, see ALTER VIEW.

CREATE

SEQUENCE

For information about the supported syntax of the CREATE SEQUENCE command, see CREATE SEQUENCE.

ALTER

SEQUENCE

For information about the supported syntax of the ALTER SEQUENCE command, see ALTER SEQUENCE.

DROP

SEQUENCE

For information about the supported syntax of the DROP SEQUENCE command, see DROP SEQUENCE.

CREATE

ROLE, WITH

CREATE

FUNCTION

LANGUAGE SQL

CREATE

DOMAIN

CREATE

SCHEMA

You can nest CREATE SEQUENCE and GRANT statements in the CREATE SCHEMA command.

ALTER

USER, ROLE, GROUP

RENAME TO

ALTER

ROUTINE

SET SCHEMA, OWNER TO, RENAME TO

COMMENT ON

ROUTINE

None

DROP

ROUTINE

None

INSERT

INTO

VALUES

SELECT

[ON CONFLICT]

UPDATE

SET

WHERE (SELECT)

FROM, WITH

GRANT

ON, TO

Supported object types include ROUTINE.

REVOKE

ON, FROM, CASCADE, RESTRICT

Supported object types include ROUTINE.

ALTER DEFAULT PRIVILEGES

Configure default privileges for TABLE, SEQUENCE, FUNCTION, and TYPE objects.

COMMIT

[WORK | TRANSACTION]

[AND NO CHAIN]

END

BEGIN

[WORK | TRANSACTION]

[ISOLATION LEVEL REPEATABLE READ]

[READ WRITE | READ ONLY]

START TRANSACTION

[ISOLATION LEVEL REPEATABLE READ]

[READ WRITE | READ ONLY]

ROLLBACK

[WORK | TRANSACTION]

[AND NO CHAIN]

ABORT