How to extract JSON response from claygent to create multiple columns for data selection

any idea how i can get the response from claygent that I get as a JSON into another column, that I can then “reselect” into more columns? So basically I want one master column, that I can then select from and create multiple columns out of it