Method parse_create_materialized_view

src/sql-parser/src/parser.rs:4094–4156

(&mut self)

    }

    fn parse_create_materialized_view(&mut self) -> Result<Statement<Raw>, ParserError> {
        let mut if_exists = if self.parse_keyword(OR) {
            self.expect_keyword(REPLACE)?;
            IfExistsBehavior::Replace
        } else {
            IfExistsBehavior::Error
        };
        let replacement = self.parse_keyword(REPLACEMENT);
        self.expect_keywords(&[MATERIALIZED, VIEW])?;
        if if_exists == IfExistsBehavior::Error && self.parse_if_not_exists()? {
            if_exists = IfExistsBehavior::Skip;
        }

        let name = self.parse_item_name()?;
        let columns = self.parse_parenthesized_column_list(Optional)?;
        let replacement_for = if replacement {
            self.expect_keyword(FOR)?;
            Some(self.parse_raw_name()?)
        } else {
            None
        };
        let (in_cluster, in_cluster_replica) = if self.parse_keywords(&[IN, CLUSTER]) {
            let cluster = self.parse_raw_ident()?;
            let replica = if self.parse_keyword(REPLICA) {
                Some(self.parse_identifier()?)
            } else {
                None
            };
            (Some(cluster), replica)
        } else if self.parse_keywords(&[IN, REPLICA]) {
            let replica = self.parse_identifier()?;
            (None, Some(replica))
        } else {
            (None, None)
        };

        let with_options = if self.parse_keyword(WITH) {
            self.expect_token(&Token::LParen)?;
            let options = self.parse_comma_separated(Parser::parse_materialized_view_option)?;
            self.expect_token(&Token::RParen)?;
            options
        } else {
            vec![]
        };

        self.expect_keyword(AS)?;
        let query = self.parse_query()?;
        let as_of = self.parse_optional_internal_as_of()?;

        Ok(Statement::CreateMaterializedView(
            CreateMaterializedViewStatement {
                if_exists,
                name,
                columns,
                replacement_for,
                in_cluster,
                in_cluster_replica,
                query,