Method parse_cte_mut_rec

src/sql-parser/src/parser.rs:7703–7723

Parse a mutually recursive CTE (`alias ( col1: typ1, col2: typ2, ... ) AS (subquery)`). The main distinction from `parse_cte` is that the column names and types are mandatory. This is not how SQL works for `WITH RECURSIVE`, but we are doing it for now to make the query interpretation that much easier.

(&mut self)

    /// This is not how SQL works for `WITH RECURSIVE`, but we are doing it for now to make the
    /// query interpretation that much easier.
    fn parse_cte_mut_rec(&mut self) -> Result<CteMutRec<Raw>, ParserError> {
        let name = self.parse_identifier()?;
        self.expect_token(&Token::LParen)?;
        let columns = self.parse_comma_separated(|parser| {
            Ok(CteMutRecColumnDef {
                name: parser.parse_identifier()?,
                data_type: parser.parse_data_type()?,
            })
        })?;
        self.expect_token(&Token::RParen)?;
        self.expect_keyword(AS)?;
        self.expect_token(&Token::LParen)?;
        let query = self.parse_query()?;
        self.expect_token(&Token::RParen)?;
        Ok(CteMutRec {
            name,
            columns,
            query,
            id: (),
        })
    }

    /// Parse a "query body", which is an expression with roughly the
    /// following grammar: