Allow WHERE clause when create table.

[st1page]

CREATE TABLE t(
    v int,
    k int primary key,
    proc_time timestamptz as proctime()
) 
WHERE proc_time > now() - 1 'day' AND v > 10
with (
    connnector = 'kafka'
) FORMAT PLAIN ENCODE JSON;

original requirement: some user want to do state cleaning on the cdc-table and we can do temporal filter on it.

[neverchanje]

I personally feel this is low-priority, because I see no popular RDBMS having TTL support. Users typically use range-partitioning to archive old data rather than deleting them, while RisingWave is already based on archive stores. There's no need for data archival.

Possible use cases for this feature can be TTL on non-CDC table, including append-only tables. TTL for append-only tables is tracked in #14791.

[github-actions]

This issue has been open for 60 days with no activity. Could you please update the status? Feel free to continue discussion or close as not planned.