Using MS SQL, literally all JSON handling is borked.
- It cannot be selected as JSON (KNIME) → JSON (DB) in the Connector
- Table Structure Creator can be defined as JSON (Knime) → nvarchar(max), but it fails and complains that no mapping for JSON has been configured
and on that same note: there are a bunch of datatypes shown (longvarchar, longnvarchar) in MS SQL connection that do not exist. Those are Oracle database types.