Since there's no context where someone will want a JSON type without the constraint, and excluding it causes compatibility problems with MySQL, why not map
CREATE TABLE t (j JSON);
CREATE TABLE t (
JSON data type
JSON type alias is insufficiently compatible
Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.