I can run the following statement just fine
select json_transform('[1,2,3]', append '$' = 4) from dual;
But Toad tells me it's wrong and I can not format it.
Currently using Toad 24.2.275.4664 and Oracle database 19c.
Btw, a related question, was an escape hatch ever added to Toad for formatting or error checking? E.g. a specific comment for Toad to disregard code that could be used in these cases where Toad is not up to date. I was told it had been planned here but since that trick still works I assume it was never implemented. Would be useful both for PL/SQL and regular SQL. Might be a good idea to have a separate one for error checking and auto formatting, maybe even an "I know what I'm doing" hint for the rule engine.
Similar issue Realtime syntax checker incorrect - v17.1, Oracle 19.20
)