[FEATURE] missing JSON_VALUE function for Oracle

[ZhengguanLi]

Grammar or Syntax Description

• JOSN_VALUE clause is not supported yet

SQL Example

• Simplified Query Example, focusing on the failing feature

  SELECT JSON_VALUE('{a:100}', '$.a' RETURNING NUMBER) AS value
  FROM DUAL;
  
  SELECT JSON_VALUE('{a:100}', '$.a' RETURNING NUMBER ON ERROR) AS value
  FROM DUAL;

  Exception:

  net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "("
      at line 1, column 18.
  Was expecting one of:
      "&"
      "::"
      "<<"
      ">>"
      "EXCEPT"
      "INTERSECT"
      "INTO"
      "MINUS"
      "UNION"
      "["
      "^"
      "|"
      <EOF>
      <ST_SEMICOLON>
  

Additional context

The used JSQLParser Version: 4.7_SNAPSHOT.
Oracle DB 12c
Links to the reference documentation: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqlrf/JSON_VALUE.html#GUID-C7F19D36-1E75-4CB2-AE67-ADFBAD23CBC2

[manticore-projects]

The most recent documentation: https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/JSON_VALUE.html#GUID-C7F19D36-1E75-4CB2-AE67-ADFBAD23CBC2