Amazon Aurora DSQL adds support for identity columns and sequence objects
Amazon Aurora DSQL now supports identity columns and sequence objects enabling developers to generate auto-incrementing, integer-based IDs directly in the database using familiar SQL patterns.
This launch simplifies migrations of existing PostgreSQL applications and supports development of new workloads that rely on database-managed integer identifiers. Developers can create compact, human-readable IDs, such as order numbers, account IDs, or operational references without custom ID generation logic in application code or middleware.
Aurora DSQL support for identity columns and sequence objects is available in all Regions where Aurora DSQL is available. To learn more, see the Aurora DSQL documentation on sequences and identity columns.