Beautifier Support for JSON_TABLE?

[Stew Stryker]

For your Enhancements Wishlist:

Please add support to Beautifier for the Oracle JSON_TABLE function.

SELECT *
  FROM json_table('[{id:"A10",cost:50,price:175,profit:125},
                    {id:"B5",cost:20,price:80,profit:60},
                    {id:"C42",cost:5,price:25,profit:20}]', '$[*]'
       COLUMNS (item_id VARCHAR2(255) PATH '$.id',
                item_cost NUMBER PATH '$.cost',
                price NUMBER PATH '$.price',
                profit NUMBER PATH '$.profit'))

I think the COLUMNS should be listed underneath each other, shown above, as in INSERT statements.

Thanks for your consideration.

Stew

 

[Marco Kalter]

I have added this to the list of enhancement requests.