Clickhouse `WITH <expression> AS <identifier>` syntax

[matthieugouel]

Hey 👋

The WITH <expression> AS <identifier> (doc here) does not seem to be supported.

For instance, this command with the ClickHouseDialect does not work (nor with GenericDialiect):

WITH concat(prefix_addr, '/', prefix_len) AS prefix SELECT prefix FROM table

sql parser error: Expected: (, found: prefix at Line: 1, Column: 46