I'm trying to create a table with this below data value:
{"name": "Tommy", "Age": 16, "date":{"string": "2020-10-10"}}
{"name": "Will", "Age": 20, "date":{"string": "2020-10-10"}}
but when I try to access data from a select it comes: {"string":"2020-10-10"} and I just need data value
there is any option to solve this on create table step? For exemple, to create a table looking to the date["string"] value.
I know, this is very specific, but if someone knows I'll be very happy! Thks