The WITH clause is defined as being a common table expression (CTE). A CTE is like a temporary result set that is defined and used for the duration of a SQL statement execution. See [here](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/queries_select_statement/with_clause/with_clause) for an example.
As it is a VQL Clause, It can be used in VQL statements to query or create views.
Denodo can send statements including the WITH clause to Oracle or to any other Database Management System that supports it. I have just tried it and it worked fine.
Moreover, in Denodo Design Studio, you could use the Create from query option (which is used for creating Base Views) to force Denodo to execute a statement in a specific way.
Hope this helps.