You can index on fields in JSONB, but I don’t believe that’s what the op is solving for here. In either scenario, I’d still generally encourage avoiding storin

You can index on fields in JSONB, but I don’t believe that’s what the op is solving for here. In either scenario, I’d still generally encourage avoiding storing JSON(B) unless there isn’t a better alternative. There are a lot of maintenance, size, I/O, and validation disadvantages to using JSON in the DB.