Kit Menke @kitmenke.com · Nov 6 Perhaps using unnest? select unnest(value, recursive := true) from read_json('~/Data/example.json')
0 likes 1 replies
?
Replies
ooh that might work. Is there a way to preserve the column names? (spoiler: I dumped it into an LLM and it spat out the hard-coded list of fields for me; but I love elegant SQL and was curious if it could be done without hardcoding)