Using a simple example of a table with just two columns—an id and a long JSON string—how can I easily return all JSON values and attributes with the attributes as columns?
I know I can readily use JSON_VALUE
and specify a specific key/attribute, but I don’t want to have a long list of numerous JSON_VALUE
for every possible key. Is there a dynamic way of doing this?
Say, for example, I have 100 JSON keys and the result should be an id column with another 100 key columns and their values?
Thank you.