When should you use JSON / JSONB columns in a relational database?

Answer preview

Use a JSONB column when the data is genuinely schemaless or externally owned — sparse per-tenant attributes, third-party webhook payloads, request snapshots, flexible config. Keep anything you join on, constrain, aggregate, or report on as a real column: JSON is a value type, not…