Function select_expr_lowered

nodedb-sql/src/resolver/expr/tests.rs:297–312

Parses `SELECT FROM t` and returns the lowered `SqlExpr` for ` `.

(sql: &str)

/// Parses `SELECT <expr> FROM t` and returns the lowered `SqlExpr` for `<expr>`.
fn select_expr_lowered(sql: &str) -> SqlExpr {
    let stmts = parse_sql(sql).expect("parse failed");
    let Statement::Query(q) = &stmts[0] else {
        panic!("expected query");
    };
    let sqlparser::ast::SetExpr::Select(sel) = q.body.as_ref() else {
        panic!("expected select body");
    };
    let raw = &sel.projection[0];
    let raw_expr = match raw {
        SelectItem::UnnamedExpr(e) => e,
        SelectItem::ExprWithAlias { expr, .. } => expr,
        other => panic!("unexpected projection: {other:?}"),
    };
    convert_expr(raw_expr).expect("convert_expr failed")
}

fn assert_json_fn(sql: &str, expected_fn: &str) {
    let expr = select_expr_lowered(sql);