ClickHouse: fail to parse "WITH <expression> AS <identifier>"

[herry13]

Description

sqlglot fails to parse WITH <expression> AS <identifier>.

Before you file an issue

• Make sure you specify the "read" dialect eg. parse_one(sql, read="spark") -- Yes, I have specified the "read" dialect.
• Check if the issue still exists on main -- I have cloned and used the latest main branch. But the issue still exists.

Fully reproducible code snippet

import sqlglot
from sqlglot.dialects.clickhouse import ClickHouse

query = "WITH 1 AS var SELECT var"
sqlglot.maybe_parse(query, dialect=ClickHouse(), error_level=sqlglot.ErrorLevel.RAISE)

Official Documentation

Link to WITH Clause syntax and its example available in the ClickHouse documentation website.

[georgesittas]

Appreciate the report @herry13, we'll take a look soon.

[herry13]

@VaggelisD Thank you for fixing this!