Select query with object

SQL++
,
1

Suppose i have a document like
Employee {
"“name”:montu,
“age”:30,
“address”:{
“street”:“27.rankin”,
“city”:“wonderland”
}
}
now i want to write query which give me data given below:
Employee {
"“name”:montu,
“address”:{
“street”:“27.rankin”
}
}

2

Reconstruct object

SELECT {d.name, "address": {d.street} } AS Employee 
FROM default AS d
WHERE .....;