AWS aurora-dsql documentation change
Summary
Restructured documentation of supported SQL features into categorized sections (SELECT, DDL, DML, DCL, TCL, Utility) with detailed command support listings and improved formatting
Security assessment
Changes focus on reorganizing existing technical documentation about SQL feature support without introducing new security content. While DCL section mentions GRANT/REVOKE commands, these were already present in previous version and the update only reformats existing security-related information rather than adding new security guidance.
Diff
diff --git a/aurora-dsql/latest/userguide/working-with-postgresql-compatibility-supported-sql-features.md b/aurora-dsql/latest/userguide/working-with-postgresql-compatibility-supported-sql-features.md index 68901e4c3..809cc567b 100644 --- a//aurora-dsql/latest/userguide/working-with-postgresql-compatibility-supported-sql-features.md +++ b//aurora-dsql/latest/userguide/working-with-postgresql-compatibility-supported-sql-features.md @@ -4,0 +5,2 @@ +SELECT commandData Definition Language (DDL)Data Manipulation Language (DML)Data Control Language (DCL)Transaction Control Language (TCL)Utility commands + @@ -7 +9 @@ Amazon Aurora DSQL is provided as a Preview service. To learn more, see [Betas a -# Supported PostgreSQL features in Aurora DSQL +# Supported SQL for Aurora DSQL @@ -9 +11 @@ Amazon Aurora DSQL is provided as a Preview service. To learn more, see [Betas a -The table below characterizes general PostgreSQL expression support for the Aurora DSQL. This list is not exhaustive. +Aurora DSQL supports a wide range of core PostgreSQL SQL features. In the following sections, you can learn about general PostgreSQL expression support. This list is not exhaustive. @@ -13 +15,70 @@ The table below characterizes general PostgreSQL expression support for the Auro -In Aurora DSQL, you might find that SQL expressions beyond those characterized below are working. Be aware that there may be changes to behavior or support for such expressions. +In Aurora DSQL, you might find that SQL expressions work even though they're not listed as supported. Be aware that changes to behavior or support are possible for such expressions. + +## SELECT command + +Aurora DSQL supports the following clauses of the `SELECT` command: + + * `FROM` + + * `GROUP BY` (with `ALL`, `DISTINCT`) + + * `ORDER BY` (with `ASC`, `DESC`, `NULLS`) + + * `LIMIT` + + * `DISTINCT` + + * `HAVING` + + * `USING` + + * `WITH` (common table expressions) + + * Join types: + + * `INNER JOIN` (with `ON`) + + * `OUTER JOIN` (with `LEFT`, `RIGHT`, `FULL`, `ON`) + + * `CROSS JOIN` (with `ON`) + + * Set operations: + + * `UNION` (with `ALL`) + + * `INTERSECT` (with `ALL`) + + * `EXCEPT` (with `ALL`) + + * `OVER` (with `RANK ()`, `PARTITION BY`) + + * `FOR UPDATE` + + + + +## Data Definition Language (DDL) + +Aurora DSQL supports the following PostgreSQL DDL commands. + +Command | Primary Clause | Supported Clauses +---|---|--- +`CREATE` | `TABLE` | `PRIMARY KEY` For information about the supported syntax of the `CREATE TABLE` command, see [CREATE TABLE](./working-with-postgresql-compatibility-supported-sql-subsets.html#create-table-syntax-support). +`ALTER` | `TABLE` | For information about the supported syntax of the `ALTER TABLE` command, see [ALTER TABLE](./working-with-postgresql-compatibility-supported-sql-subsets.html#alter-table-syntax-support). +`DROP` | `TABLE` | +`CREATE` | `INDEX` | You can run this command on the following: + + * Empty tables + * `ON`, `NULLS FIRST`, or `NULLS LAST` parameter + + +`CREATE` | `INDEX ASYNC` | You can use this command with the following parameters: `ON`, `NULLS FIRST`, `NULLS LAST`. For information about the supported syntax of the `CREATE INDEX ASYNC` command, see [Creating async indexes in Aurora DSQL](./working-with-create-index-async.html). +`DROP` | `INDEX` | +`CREATE` | `VIEW` | For more information about the supported syntax of the `CREATE VIEW` command, see [CREATE VIEW ](./working-with-postgresql-compatibility-supported-sql-subsets.html#create-view). +`ALTER` | `VIEW` | For information about the supported syntax of the `ALTER VIEW` command, see [ALTER VIEW](./working-with-postgresql-compatibility-supported-sql-subsets.html#alter-view-syntax-support). +`DROP` | `VIEW` | For information about the supported syntax of the `DROP VIEW` command, see [DROP VIEW ](./working-with-postgresql-compatibility-supported-sql-subsets.html#drop-view-overview). +`CREATE` | `ROLE`, `WITH` | +`CREATE` | `FUNCTION` | `LANGUAGE SQL` +`CREATE` | `DOMAIN` | + +## Data Manipulation Language (DML) @@ -15 +86,3 @@ In Aurora DSQL, you might find that SQL expressions beyond those characterized b -Category | Primary Clause | Supported Clauses +Aurora DSQL supports the following PostgreSQL DML commands. + +Command | Primary clause | Supported clauses @@ -17,44 +90,40 @@ Category | Primary Clause | Supported Clauses -SELECT | FROM | see SELECT rows -SELECT | GROUP BY | ALL, DISTINCT -SELECT | ORDER BY | ASC, DESC, NULLS .. -SELECT | LIMIT | -SELECT | DISTINCT | -SELECT | HAVING | -SELECT | WITH | -SELECT | USING | -SELECT | INNER JOIN | ON -SELECT | OUTER JOIN | LEFT, RIGHT, FULL, ON -SELECT | CROSS JOIN | ON -SELECT | OVER | RANK (), PARTITION BY -SELECT | UNION | UNION ALL -SELECT | INTERSECT | INTERSECT ALL -SELECT | EXCEPT | EXCEPT ALL -SELECT | FOR UPDATE | -INSERT | INTO | VALUES -INSERT | INTO | SELECT, WITH -UPDATE | SET | WHERE, WHERE (SELECT) -UPDATE | SET | FROM, WITH -CREATE | TABLE | PRIMARY KEY For information about the syntax of the `CREATE TABLE` command that Aurora DSQL supports, see [CREATE TABLE](./working-with-postgresql-compatibility-supported-sql-subsets.html#create-table-syntax-support). -CREATE | INDEX | Can run on the following: - - * Empty tables. - * ON, NULLS FIRST, or NULLS LAST parameter. - - -CREATE | INDEX ASYNC | ON, NULLS FIRST, NULLS LAST For information about the syntax of the `CREATE INDEX ASYNC` command that Aurora DSQL supports, see [Creating async indexes in Aurora DSQL](./working-with-create-index-async.html). -CREATE | VIEW | For more information about the syntax of the `CREATE VIEW` command that Aurora DSQL supports, see [CREATE VIEW ](./working-with-postgresql-compatibility-supported-sql-subsets.html#create-view). -DROP | TABLE | -DROP | INDEX | -DROP | VIEW | For information about the syntax of the `DROP VIEW` command that Aurora DSQL supports, see [DROP VIEW ](./working-with-postgresql-compatibility-supported-sql-subsets.html#drop-view-overview). -DELETE | FROM | USING, WHERE -GRANT | [permission] | ON, TO -REVOKE | [permission] | ON, FROM, CASCADE, RESTRICT -CREATE | ROLE, WITH | -CREATE | FUNCTION | LANGUAGE SQL -EXPLAIN | - | - -BEGIN | [WORK | TRANSACTION] [READ ONLY | READ WRITE | -COMMIT | | -ANALYZE | | relation name only -CREATE | DOMAIN | -ALTER | TABLE | For information about the syntax of the `ALTER TABLE` command that Aurora DSQL supports, see [ALTER TABLE](./working-with-postgresql-compatibility-supported-sql-subsets.html#alter-table-syntax-support). -ALTER | VIEW | For information about the syntax of the `ALTER VIEW` command that Aurora DSQL supports, see [ALTER VIEW](./working-with-postgresql-compatibility-supported-sql-subsets.html#alter-view-syntax-support). +`INSERT` | `INTO` | `VALUES``SELECT` +`UPDATE` | `SET` | `WHEREWHERE (SELECT)`, `WHERE (SELECT)` `FROM, WITH` +`DELETE` | `FROM` | `USING`, `WHERE` + +## Data Control Language (DCL) + +Aurora DSQL supports the following PostgreSQL DCL commands: + + * `GRANT` (with `ON`, `TO`) + + * `REVOKE` (with `ON`, `FROM`, `CASCADE`, `RESTRICT`) + + + + +## Transaction Control Language (TCL) + +Aurora DSQL supports the following PostgreSQL TCL commands: + + * `COMMIT` + + * `BEGIN` with either of the following clauses: + + * [`WORK` | `TRANSACTION`] + + * [`READ ONLY` | `READ WRITE`] + + + + +## Utility commands + +Aurora DSQL supports the following PostgreSQL utility commands: + + * `EXPLAIN` + + * `ANALYZE` (relation name only) + + +