Function json_array_contains 

pub fn json_array_contains<'a, L, R>(
    left: L,
    path: &'a str,
    value: R,
) -> SQL<'a, SQLiteValue<'a>>
where
    L: ToSQL<'a, SQLiteValue<'a>>,
    R: Into<SQLiteValue<'a>>,

Builds an EXISTS test that is true when the JSON array at path has an element equal to value.

Examples

let column = SQL::<SQLiteValue>::raw("metadata");
let condition = json_array_contains(column, "$.preferences", "dark_theme");
assert_eq!(
    condition.sql(),
    "EXISTS(SELECT 1 FROM json_each( metadata , ? ) WHERE value = ? )"
);