Function json_extract 

pub fn json_extract<'a, L>(left: L, path: impl AsRef<str>) -> SQLiteSQL<'a>
where
    L: ToSQL<'a, SQLiteValue<'a>>,

Helper function for JSON extraction using ->> operator

Example

let column = SQL::<SQLiteValue>::raw("metadata");
let extract_expr = json_extract(column, "theme");
assert_eq!(extract_expr.sql(), "metadata ->>'theme'");