Function first_select_expr

nodedb-sql/src/resolver/expr/tests.rs:12–25

Extract the first SELECT item expression from a simple `SELECT FROM `.

(sql: &str)

/// Extract the first SELECT item expression from a simple `SELECT <expr> FROM <tbl>`.
fn first_select_expr(sql: &str) -> Expr {
    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");
    };
    match &sel.projection[0] {
        SelectItem::UnnamedExpr(e) => e.clone(),
        SelectItem::ExprWithAlias { expr, .. } => expr.clone(),
        other => panic!("unexpected projection item: {other:?}"),
    }
}

#[test]
fn compound_identifier_two_parts_is_column() {