I hope its ok to ask a question more specific to Postgres than Prisma. I read this section on Prisma docs on Json support and as a postgres newbie, I am keen to learn about json (specifically jsonb) usage in postgres with Prisma. Is there any guide, more docs to refer to, for using jsonb (converting to/from etc) in postgres via Prisma?

@SKhan 👋 Currently we support adding values and filtering on Json fields.

Thank you @Ryan. Is there a link to how to use this because, it just being a field, I thought, it is immutable. I.e, we extract the value from Postgres and then update the json etc and then over-write the json field in table.

Yes currently that’s the only way to update a Json field. At the moment, only advanced filtering is supported.

I see. Thank you for the help as always. ❤️