Should we aim to unify queries with semi-structured access?

[yoavcloud]

Hello,

I've noticed that queries that use semi-structured access are parsed differently in different dialects.

Snowflake uses the JsonAccess struct:

let sql = "SELECT a:b FROM t";
    let select = snowflake().verified_only_select(sql);
    assert_eq!(
        SelectItem::UnnamedExpr(Expr::JsonAccess {
            value: Box::new(Expr::Identifier(Ident::new("a"))),
            path: JsonPath {
                path: vec![JsonPathElem::Dot {
                    key: "b".to_owned(),
                    quoted: false
                }]
            },
        }),
        select.projection[0]
    );

PostgreSQL relies on BinaryOperator:

    let sql = "SELECT params ->> 'name' FROM events";
    let select = pg().verified_only_select(sql);
    assert_eq!(
        SelectItem::UnnamedExpr(Expr::BinaryOp {
            left: Box::new(Expr::Identifier(Ident::new("params"))),
            op: BinaryOperator::LongArrow,
            right: Box::new(Expr::Value(Value::SingleQuotedString("name".to_string()))),
        }),
        select.projection[0]
    );

As library consumers, we work with most dialects. However, the same query semantics produce different structures, and we must support these different cases. This raises the question: to what extent do we want the sqlparser library to provide semantics in addition to syntax?