SelectWithUnionQuery (children 1)
 ExpressionList (children 1)
  SelectQuery (children 3)
   ExpressionList (children 1)
    WithElement (children 1)
     Subquery (children 1)
      SelectWithUnionQuery (children 1)
       ExpressionList (children 2)
        SelectQuery (children 1)
         ExpressionList (children 2)
          Literal UInt64_1 (alias id)
          Function CAST (alias path) (children 1)
           ExpressionList (children 2)
            Literal \'[]\'
            Literal \'Array(UInt64)\'
        SelectQuery (children 2)
         ExpressionList (children 2)
          Identifier tree.id
          Function arrayConcat (children 1)
           ExpressionList (children 2)
            Identifier t.path
            Function array (children 1)
             ExpressionList (children 1)
              Identifier tree.id
         TablesInSelectQuery (children 2)
          TablesInSelectQueryElement (children 1)
           TableExpression (children 1)
            TableIdentifier tree
          TablesInSelectQueryElement (children 2)
           TableExpression (children 1)
            TableIdentifier t
           TableJoin (children 1)
            Function equals (children 1)
             ExpressionList (children 2)
              Identifier tree.parent_id
              Identifier t.id
   ExpressionList (children 3)
    Identifier t1.id
    Identifier t2.path
    Function tuple (children 1)
     ExpressionList (children 1)
      QualifiedAsterisk (children 1)
       Identifier t2
   TablesInSelectQuery (children 2)
    TablesInSelectQueryElement (children 1)
     TableExpression (children 1)
      TableIdentifier t (alias t1)
    TablesInSelectQueryElement (children 2)
     TableExpression (children 1)
      TableIdentifier t (alias t2)
     TableJoin (children 1)
      Function equals (children 1)
       ExpressionList (children 2)
        Identifier t1.id
        Identifier t2.id
