Unlocking Time to Live (TTL) in YSQL

The YCQL API supports Time to Live (TTL) functionality, but YSQL does not currently offer this feature. However, database partitions can be used to achieve similar results in a straightforward manner. To implement TTL, you can create a table and partition it based on a date or time column, then detach the partition when a certain period has passed, allowing for automated management once pg_partman support is available.