How well does Aurora DSQL support Range Types?

Based on the available documentation, Aurora DSQL does not explicitly list range types (including tsrange) among its supported data types. Aurora DSQL is based on PostgreSQL version 16 and supports a subset of PostgreSQL data types, but range types are not mentioned in the supported data types documentation.

The supported data types in Aurora DSQL are categorized into numeric, character, date and time, miscellaneous, and query runtime types. While Aurora DSQL supports the interval data type for time spans, there is no specific mention of range types like tsrange.

For your use case of querying based on start_time and end_time, you would likely need to use separate timestamp fields rather than a tsrange type in Aurora DSQL. While PostgreSQL itself supports range types (including float8_range as shown in one example), this feature does not appear to be included in the current Aurora DSQL implementation.

Since Aurora DSQL aims to provide identical results for all supported PostgreSQL syntax, features not explicitly listed as supported should be considered unavailable until documented otherwise.
Sources
Supported data types in Aurora DSQL - Amazon Aurora DSQL
User-defined types for T-SQL - SQL Server to Aurora PostgreSQL Migration Playbook
Aurora DSQL and PostgreSQL - Amazon Aurora DSQL
Supported SQL for Aurora DSQL - Amazon Aurora DSQL
SQL feature compatibility in Aurora DSQL - Amazon Aurora DSQL