Special data types ​

Interval represents a signed quantity with one calendar or elapsed-time unit. Use it for date arithmetic rather than storing a duration as an unlabelled integer.

SELECT CAST('2024-01-31' AS Date) + INTERVAL 1 MONTH
FORMAT csv;

"2024-02-29"

Other special names ​

Expression, Set and Nothing have no dedicated native declarations in CoordinatorDB. Unrecognized type names follow legacy SQL affinity; declaring a column as Nothing does not restrict it to NULL.

Use Nullable and SQL constraints for nullability, and the supported type reference to choose a validated native declaration.