Constructing and Destructing Objects (JSON)

[bubbajoe]

Is your feature request related to a problem or challenge?

Hello,

I am having a problem where i can't handle/use destruct object data. So i figured i'd create an issue and attempt to figure constructing as well. Is there any plan to add full object/json support?

Describe the solution you'd like

https://www.postgresql.org/docs/9.5/functions-json.html

Operators listed at the top and the functions listed below

Describe alternatives you've considered

No response

Additional context

No response

[alamb]

Thanks @bubbajoe -- I added this to our current list at #2326

It would be great to add this feature

[alamb]

See also #7845

[alamb]

I think this is covered by #7845 so let's keep the discussion going there