Support with arrayJoin .. as .. expression (ClickHouse)

[xtess16]

Code snippet

from sqlglot import dialects, parse_one

sql = """
with arrayJoin([(1, [2, 3])]) as arr
select arr
"""

parse_one(sql=sql, dialect=dialects.ClickHouse)

Python 3.11
sqlglot 26.0.1

Expected: successful parsing
Actual:

ParseError: Required keyword: 'this' missing for <class 'sqlglot.expressions.Alias'>. Line 3, Col: 6.
  
with arrayJoin([(1, [2,3])]) as arr
select arr

Official Documentation
WITH
arrayJoin

Check the correctness of the expression
Tap