Method parse_declare

src/sql-parser/src/parser.rs:9303–9330

Parse a `DECLARE` statement, assuming that the `DECLARE` token has already been consumed.

(&mut self)

    /// Parse a `DECLARE` statement, assuming that the `DECLARE` token
    /// has already been consumed.
    fn parse_declare(&mut self) -> Result<Statement<Raw>, ParserStatementError> {
        let name = self
            .parse_identifier()
            .map_parser_err(StatementKind::Declare)?;
        self.expect_keyword(CURSOR)
            .map_parser_err(StatementKind::Declare)?;
        if self.parse_keyword(WITH) {
            let err = parser_err!(
                self,
                self.peek_prev_pos(),
                format!("WITH HOLD is unsupported for cursors")
            )
            .map_parser_err(StatementKind::Declare);
            self.expect_keyword(HOLD)
                .map_parser_err(StatementKind::Declare)?;
            return err;
        }
        // WITHOUT HOLD is optional and the default behavior so we can ignore it.
        let _ = self.parse_keywords(&[WITHOUT, HOLD]);
        self.expect_keyword(FOR)
            .map_parser_err(StatementKind::Declare)?;
        let StatementParseResult { ast, sql } = self.parse_statement()?;
        Ok(Statement::Declare(DeclareStatement {
            name,
            stmt: Box::new(ast),
            sql: sql.to_string(),
        }))
    }

    /// Parse a `CLOSE` statement, assuming that the `CLOSE` token
    /// has already been consumed.