Query custom SQL data within visual Query

[Adrianilloo]

Hello,

When using a standard "visual" Query object in a report, is it possible to run SQL code referencing custom DB tables, package functions, etc? I know we can already use "provider specific functions" such as {sysdate} in case of using Oracle.

Concretely I wish to compare a visually added field with a custom DB package function returned value as in a classic SELECT, for a Detail filter. I'm using Oracle RDBMS.

I could create the whole logic prepending a SQL object within the visual query, but I'd like to mix both styles within the standard/visual query.

Thank you.