Function register_array_overlap

src/functions/array_functions.rs:423–447

array_overlap(array1, array2) - Check if arrays have common elements

(conn: &Connection)

/// array_overlap(array1, array2) - Check if arrays have common elements
fn register_array_overlap(conn: &Connection) -> Result<()> {
    conn.create_scalar_function(
        "array_overlap",
        2,
        FunctionFlags::SQLITE_UTF8 | FunctionFlags::SQLITE_DETERMINISTIC,
        |ctx| {
            let array1_json: String = ctx.get(0)?;
            let array2_json: String = ctx.get(1)?;
            
            match (
                serde_json::from_str::<JsonValue>(&array1_json),
                serde_json::from_str::<JsonValue>(&array2_json),
            ) {
                (Ok(JsonValue::Array(arr1)), Ok(JsonValue::Array(arr2))) => {
                    // Check if any element of arr1 is in arr2
                    let has_overlap = arr1.iter().any(|elem| arr2.contains(elem));
                    Ok(has_overlap)
                }
                _ => Ok(false),
            }
        },
    )?;
    
    Ok(())
}

/// array_slice(array, start, end) - Extract slice from array (1-based indexing)
fn register_array_slice(conn: &Connection) -> Result<()> {