Add support for Schema.JSON type.

Use mysql-adapter as inspiration. All existing tests still pass, didn't have time to look into adding some specific ones for the Schema.JSON type.