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

Hey 👋

The `WITH AS ` (doc [here](https://clickhouse.com/docs/en/sql-reference/statements/select/with)) 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
```

首先使用 ClickHouseDialect 和 GenericDialect 重现所提供的查询，并以第 1 行第 46 列报告的解析器错误作为切入点。沿着 WITH 的解析路径，确定表达式加标识符形式是如何处理的；完成的标准是该示例能够针对相关方言成功解析。

由索引模型根据 Issue 内容生成。