Parsing CAST function in MySQL

[1ilit]

Describe the bug
Throws SyntaxError when parsing CAST()

Database Engine
MySQL

To Reproduce
-the SQL that be parsed

CREATE TABLE some_table (
    col JSON,
    KEY `idx_col` ((CAST(`col` AS CHAR(12) ARRAY)))
);

-the node-sql-parser version
v5.1.0
-the node version
v18.20.3

Expected behavior
Produce ast

Additional context
Minimal reproducible example: https://stackblitz.com/edit/stackblitz-starters-9dpxty?file=index.js