JSONB data type updates require fetch-spread-repost pattern

6/10 Medium

Prisma lacks native support for updating JSONB fields in PostgreSQL/MySQL, requiring developers to fetch the entire object, spread it, modify it, and re-post it instead of using direct partial updates.

Prisma
Category
architecture
Workaround
hack
Stage
build
Freshness
persistent
Scope
single_lib
Upstream
open
Recurring
Yes
Buyer Type
team
Maintainer
active

Sources

Collection History

Query: “What are the most common pain points with Prisma for developers in 2025?”4/4/2026

Prisma supports JSONB datatypes in Postgresql and MySQL. However, there is no way to update such data type. The existing way is to fetch the whole object, spread it, and then add or delete data, then post the same object again.

Created: 4/4/2026Updated: 4/4/2026