[BUG] JSQLParser 5.4-SNAPSHOT : Clickhouse : ORDER BY after CREATE TABLE unsupported

[tomershay]

The parser doesn't support an ORDER BY statement after a CREATE TABLE, which is usually used to define the physical sort order of the table.

This capability is supported in latest Clickhouse.

Sample query:

CREATE TABLE metrics (
    event_date Date,
    user_id UInt64,
    value Float64
) ENGINE = MergeTree()
ORDER BY (event_date, user_id);

Error: ParseException: Encountered: <K_ORDER> / "ORDER", at line 6, column 1, in lexical