Function plan_sql_with_params

nodedb-sql/src/lib.rs:98–123

Plan SQL with bound parameters (prepared statement execution). Parses the SQL (which may contain `$1`, `$2`, ... placeholders), substitutes placeholder AST nodes with concrete literal values from `params`, then plans normally. This avoids SQL text substitution entirely — parameters are bound at the AST level, not the string level.

(
    sql: &str,
    params: &[ParamValue],
    catalog: &dyn SqlCatalog,
)

/// normally. This avoids SQL text substitution entirely — parameters are bound
/// at the AST level, not the string level.
pub fn plan_sql_with_params(
    sql: &str,
    params: &[ParamValue],
    catalog: &dyn SqlCatalog,
) -> Result<Vec<SqlPlan>> {
    // Array DDL/DML never carries `$N` placeholders, but be defensive:
    // intercept the same way as the no-params path so the array surface
    // is reachable even if a client uses extended-query mode.
    if let Some(stmt) = try_parse_array_statement(sql)? {
        let _ = params; // arrays don't accept bound params today
        return plan_array_statement(stmt, catalog);
    }
    let preprocessed = preprocess::preprocess(sql)?;
    let effective_sql = preprocessed.as_ref().map_or(sql, |p| p.sql.as_str());
    let is_upsert = preprocessed.as_ref().is_some_and(|p| p.is_upsert);
    let temporal = preprocessed
        .as_ref()
        .map(|p| p.temporal)
        .unwrap_or_default();

    let mut statements = parse_sql(effective_sql)?;
    for stmt in &mut statements {
        params::bind_params(stmt, params);
    }
    plan_statements(&statements, is_upsert, temporal, catalog)
}

/// Plan a list of parsed statements.
fn plan_statements(