Method parse_extract_expr

src/sql-parser/src/parser.rs:1058–1076

Parse calls to extract(), which can take the form: - extract(field from 'interval')

(&mut self)

    // Parse calls to extract(), which can take the form:
    // - extract(field from 'interval')
    fn parse_extract_expr(&mut self) -> Result<Expr<Raw>, ParserError> {
        self.expect_token(&Token::LParen)?;
        let field = match self.next_token() {
            Some(Token::Keyword(kw)) => Ident::from(kw).into_string(),
            Some(Token::Ident(id)) => self.new_identifier(id)?.into_string(),
            Some(Token::String(s)) => s,
            t => self.expected(self.peek_prev_pos(), "extract field token", t)?,
        };
        self.expect_keyword(FROM)?;
        let expr = self.parse_expr()?;
        self.expect_token(&Token::RParen)?;
        Ok(Expr::Function(Function {
            name: RawItemName::Name(UnresolvedItemName::unqualified(ident!("extract"))),
            args: FunctionArgs::args(vec![Expr::Value(Value::String(field)), expr]),
            filter: None,
            over: None,
            distinct: false,
        }))
    }

    fn parse_row_expr(&mut self) -> Result<Expr<Raw>, ParserError> {
        self.expect_token(&Token::LParen)?;