pub fn json_gt<'a, L, R>(
left: L,
path: &'a str,
value: R,
) -> SQL<'a, SQLiteValue<'a>>Expand description
Builds CAST(json_extract(left, path) AS NUMERIC) > value: the number
at path is greater than value.
ยงExamples
let column = SQL::<SQLiteValue>::raw("metadata");
let condition = json_gt(column, "$.score", 85.0);
assert_eq!(condition.sql(), "CAST(json_extract( metadata , ? ) AS NUMERIC) > ?");