| base | PostgreSQL | MySQL | |
| SQL: standard complaince | high | medium | |
| max SQL length | undefined same as PostgreSQL with "StringInfo" container | | maximal SQL statement length |
| PL: main | SQL + PL/PgSQL | SQL + SP | main programming lanage: most database suports SQL because SQL is a well established standard. However, each database would like to extend SQL more or less. |
| PL: other language support | yes | no | PL lanaguage other than PL/SQL, like PL/Java, PL/Rust etc |
| SP: max parameters | 100 | | |
| UDF: max parameters | 100 | | |
| SQL: max parameters | 65535 | | number of parameters in a PREPARED query |
| SQL: query hints | GUC only | | if it allows use query hints to guide the optimizer |
| SQL: explicit locking | yes: row, page, table level | | Locking is usually an internal matter - so does it allow explicit locking? What levels do they support? |
| Triggers? | yes | | If support triggers |
| Triggers: scope | tables, views, foreign tables | | What objects can have triggers |
| Triggers: type | BEFORE, AFTER, INSTEAD OF | | Types of triggers supported |
| Object-Relational? | yes | no | |
| Extension Mechanism | C programming, link with engine | | |
| vector search | no native | no native | does it support vector search |
Comparison: Aurora DSQL vs Aurora MySQL