Function is_read_only_query

src/session/read_only_handler.rs:165–176

Check if a SQL query is read-only

(sql: &str)

/// Check if a SQL query is read-only
fn is_read_only_query(sql: &str) -> bool {
    let sql_upper = sql.trim().to_uppercase();
    
    // Allow only SELECT statements and certain pragmas
    sql_upper.starts_with("SELECT") 
        || sql_upper.starts_with("WITH") // CTEs
        || sql_upper.starts_with("EXPLAIN")
        || sql_upper.starts_with("PRAGMA TABLE_INFO")
        || sql_upper.starts_with("PRAGMA INDEX_LIST")
        || sql_upper.starts_with("PRAGMA FOREIGN_KEY_LIST")
        // Add other read-only pragmas as needed
}


#[cfg(test)]