How ca we parse JSON / Array of Objects coming as a column?
There is an option to unfold a json for some databases:
You will get the key, value pairs as a new column. If you want to apply specific transformations on a JSON/Array object then you should do that directly at SQL level
