JSON can easily be queried from SQL using - simple dot notation - `json_value` - `json_query` - `json_exists` - `json_mergepatch` - `json_transform` - `json_table`