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.