TEXT, NTEXT, SQL_VARIANT and IMAGE types cannot be used as column types in OPENJSON function with explicit schema.

It can be challenging to pick the right data type. You may start with a text field to store your email addresses and then later realize there is an Email type. Maybe you picked DateTime when really ...