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 | KEY SHARE }

Transaction limits apply. For more information, see Cluster quotas and database limits in Amazon Aurora DSQL. To understand how this impacts concurrent transactions, see Concurrency control in Aurora DSQL.

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

STATISTICS

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

ALTER

STATISTICS

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

DROP

STATISTICS

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

CREATE

VIEW

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

ALTER

VIEW

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

DROP

VIEW

For information about the supported syntax of the DROP VIEW command, see DROP 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

DELETE

FROM

USING, WHERE

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

SET CONSTRAINTS

{ALL | name [, ...]}

{DEFERRED | IMMEDIATE}