Function json_extract_text 

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

Builds left -> path, which returns the value at path as JSON text (strings stay quoted, objects and arrays stay JSON).

Use json_extract to get a plain SQL value instead.

Examples

let column = SQL::<SQLiteValue>::raw("metadata");
let extract_expr = json_extract_text(column, "preferences");
assert_eq!(extract_expr.sql(), "metadata -> ?");