You can validate JSON columns at 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