Function is_side_effect_sql

nodedb/src/control/planner/procedural/validate.rs:32–53

Returns true if the SQL string begins with a side-effecting keyword that is not permitted inside a function body.

(sql: &str)

/// Returns true if the SQL string begins with a side-effecting keyword that is
/// not permitted inside a function body.
fn is_side_effect_sql(sql: &str) -> bool {
    let upper = sql.trim().to_uppercase();
    let first_word = upper.split_ascii_whitespace().next().unwrap_or("");
    matches!(
        first_word,
        "INSERT"
            | "UPDATE"
            | "DELETE"
            | "PUBLISH"
            | "CREATE"
            | "DROP"
            | "ALTER"
            | "TRUNCATE"
            | "GRANT"
            | "REVOKE"
            | "COMMIT"
            | "ROLLBACK"
            | "SAVEPOINT"
            | "RELEASE"
            | "COPY"
    )
}

fn validate_statement(stmt: &Statement, loop_depth: usize) -> Result<(), ProceduralError> {
    match stmt {