Does the data explorer support json extracts?

Do I understand correctly Data Explorer does not support Json Extracts?

I tried, it returns the error:

PG::UndefinedFunction: ERROR: function json_extract(text, unknown) does not exist

HINT: No function matches the given name and argument types. You might need to add explicit type casts.


That is a MySQL function, but Data Explorer queries Discourse’s PostgreSQL database instead.

Based on this SO answer, you’re looking for Postgres’ @> operator for JSON data types:


Thank you! It was actually more like json_extract_path_text and helped construct a nice query for Falco’s Disorder here