Why have SQL databases like PostgresSQL and MySQL added JSON data types? I'm looking for scenarios in which storing a JSON object in a relational database would be useful.
Anywhere you have or need EAV table, it's another way to solve the problem. Or anywhere you accept JSON, especially if the JSON is arbitrary.