JSON_TABLE: Some data types cause parsing error: ENUM, SET, geometry, INET6

MariaDB [test]> select * from json_table('["foo"]', '$[*]' columns(a enum('foo','bar') path '$')) a;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'enum('foo','bar') path '$')) a' at line 1

MySQL [test]> select * from json_table('["foo"]', '$[*]' columns(a enum('foo','bar') path '$')) a;

+------+

| a    |

+------+

| foo  |

+------+

1 row in set (0.001 sec)