[BUG] JSQLParser 5.4-SNAPSHOT : Clickhouse : MATERIALIZED not supported in Clickhouse CREATE TABLE

[tomershay]

The parser doesn't support materializing columns in Clickhouse CREATE TABLE statement

The MATERIALIZED keyword makes the column auto-computed and stored from an expression.

Sample query:

CREATE TABLE t (
    url String,
    domain String MATERIALIZED regexpExtract(url, '^(?:https?://)?([^/]+)', 1)
)
ENGINE = MergeTree()
ORDER BY tuple();

Error: ParseException: Encountered: <K_MATERIALIZED> / "MATERIALIZED", at line 3