[Feature] [array-type] Support ArrayLiteral in SQL.

[adonis0147]

Search before asking

• I had searched in the issues and found no similar issues.

Description

This issue is a sub task of #7570 .

Support ArrayLiteral in SQL.
An array literal is a list of zero or more expressions, each of which represents an array element, enclosed in square brackets (eg. [1, 2, 3]).

Use case

mysql> create table array_type_table(k1 INT, k2 Array<int>) duplicate key (k1)
    -> distributed by hash(k1) buckets 1 properties('replication_num' = '1');
mysql> insert into array_type_table values (1, [1, 2, 3]);

Related issues

#7570

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct