SQL: JSON_EXTRACT

Syntax:

select <columns>
from <table>
where json_extract(<column_with_json_data>, '$<json_path>')

Example:

select id, key_details
from client_report
where json_extract(key_details, '$.mortgages') > 0