PL/SQL JSON_OBJECT support

[chrisafl]

The parser understands the JSON_OBJECT keyword but doesn't seem to understand the nested items underneath it.

JSON_OBJECT converts simple columns into a JSON object.

The below example maps jt.my_column to the JSON attribute MY_COLUMN and jt.my_other_column to the JSON attribute MY_OTHER_COLUMN.

SELECT json_object( 'MY_COLUMN' VALUE jt.my_column, 'MY_OTHER_COLUMN' VALUE jt.my_other_column) AS new_json_object FROM json_table jt;

I believe similar structures such as JSON_TABLE, which does the reverse (takes a JSON string and parses it to columns) are also not working.

Is it possible to add support for working with JSON within Oracle?