The extension flags correct syntax of SQL function json_transform() as error.
This is related to a bug in the documentation, I just reported.
prompt order of returning and passing follows documentation
prompt is not flagged but gives error ORA-00907: missing right parenthesis
select json_transform(json('[{id:1,b:"hello"},{id:2,b:"hello"}]')
, remove '$[*]?(@.id == $id)'
returning json
passing 2 as "id"
) as doc_but_wrong;
prompt this order is working
select json_transform(json('[{id:1,b:"hello"},{id:2,b:"hello"}]')
, remove '$[*]?(@.id == $id)'
passing 2 as "id" -- this is not an error
returning json) as working;