json_extract

grafbase_sql_ast::ast

Function json_extract 

Source 
pub fn json_extract<'a, C, P>(
    column: C,
    path: P,
    extract_as_string: bool,
) -> Function<'a>
where
    C: Into<Expression<'a>>,
    P: Into<JsonPath<'a>>,
Expand description

Extracts a subset of a JSON blob given a path. Two types of paths can be used:

  • String paths, referring to JSON paths. This is supported by MySQL only.
  • Array paths, supported by Postgres only.