JSON_
Parameters
json
The column containing the JSON string to iterate over. This can be any column type, as it will be treated as text.
path
An optional JSON path to a specific object or array within the JSON string. If provided, json_each will iterate over that nested element instead of the root.