You can validate JSON columns at the database level

You can validate JSON columns at the database level

⚡️ Database Tip

Extending a traditional database schema with NoSQL-like JSON columns can make the schema more understandable. But you should also ensure these JSON documents conform to an expected schema!

https://sqlfordevs.com/json-schema-validation

We're writing a book, you can get it for free here.