Support for JSON_TABLE function from mysql

[Sxxjava]

It seems that the following json function is not supported:
Failed to process, Error SQL:
SELECT
epcItem.epc
FROM
s_delivery_bill_detail detail
CROSS JOIN JSON_TABLE (
detail.epc_list,
'$[*]' COLUMNS (
epc VARCHAR ( 24 ) path '$.epc'
)
) epcItem
WHERE
bill_id = ?
.....
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "(" at line 5, column 35. Was expecting one of:
....
Json is an important data type, the support for these will be useful.

[manticore-projects]

Greetings.

It is not supported since it is far away from any standard. Since I see no point in that construct (why not just provide a `Sub Query with JSON columns?!) you would need to provide or sponsor an implementation to make it happen.