Hubert Lubaczewski makes note of some forthcoming functionality:
Back in March/April of 2022 Andres Dunstan committed a series of patches that added support for lots of really interesting features from SQL/JSON standard.
While I’m not avid user of json in database, I was very, very happy. Wrote couple of blogposts about it.
Then, around six month later they got reverted.
Lately, since last year, actually, these re-appeared again:
Read on for the list of commits and the current state of things with respect to implementing the SQL/JSON standard in Postgres.