The support for Time-To-Live (TTL) in relational databases like RDBMS is limited, whereas it's a common feature in NoSQL databases. Developers have identified various use cases where TTL would be beneficial, such as managing temporary data, generating aggregated data, and archiving old data. Couchbase has introduced the N1QL syntax to support TTL, allowing users to set expiration times directly in their queries. The N1QL syntax includes optional parameters like OPTIONS that can be used to customize the behavior of TTL. Users can also create indexes on the expiration field to improve query performance. However, there are performance considerations to keep in mind when using TTL, such as additional overhead due to the SUBDOC API.