Support PARTITION functionality in Schema.sql

[ZichaoNickFox]

I need to use PARTITION to divide candle table into partitioned tables by datetime which has 1 billion rows of candles.

CREATE TABLE candle_1m (
    symbol_id UUID NOT NULL,
    datetime TIMESTAMP WITHOUT TIME ZONE NOT NULL,
    open REAL NOT NULL,
    "close" REAL NOT NULL,
    high REAL NOT NULL,
    low REAL NOT NULL,
    volume REAL NOT NULL,
    amount REAL NOT NULL,
    PRIMARY KEY(symbol_id, datetime)
) PARTITION BY RANGE (datetime);
CREATE TABLE candle_1m_2025_01
PARTITION OF candle_1m
FOR VALUES FROM ('2025-01-01') TO ('2025-02-01');

But Schema designer seems not to support it.

I searched many resources and AIs. They say PARTITION is a center functionality rather than an edge one, which is commonly used.
So could you support PARTITION for Schema designer?

[mpscholten]

The IHP Postgres parser doesn't support this yet, but there's no way it shouldn't work (it's mostly that no one before used this feature yet)