The following statement works in Oracle Database 23ai but produces a syntax error in the VS Code extension 24.3.1.
select json_query(
'[{"a": 10}, {"a": 20}, {"a": 30}, {"a": 15}]',
'$.a?(@<=$p)'
passing 15 as "p"
with wrapper
) as result;
Here's the screenshot showing the complete error message:
