Function json_get_text_idx 

pub fn json_get_text_idx<'a, E>(
    expr: E,
    index: i32,
) -> SQLExpr<'a, PostgresValue<'a>, Text, Null, Scalar>
where
    E: Expr<'a, PostgresValue<'a>>,

PostgreSQL ->> operator with integer index - get JSON array element as text.

Example

let data = SQL::<PostgresValue>::raw("data");
let elem = json_get_text_idx(data, 0);
assert!(elem.to_sql().sql().contains("->>"));