Document situations when jsonb is appropriate to use (and when it's not)

Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.

• Close this issue

PostgreSQL has a jsonb datatype and corresponding operators. This means, we can store JSON and query its contents from the database. This has various associated problems and is not meant to replace proper relational modeling (normalization etc.).

In this issue, we document when choosing jsonb is appropriate. We have a couple of examples where this is being used and where it makes sense to use it. It'll be useful to find scenarios where it's not appropriate to use and explain why and what the alternative is.

This is a follow-up to #219134 (comment 350176395).