Given that OAS and OAC do not support the use of direct SQL queries that contain CTEs and that the use of CTEs is widely accepted and often preferred practice in highly complex queries. It would be great if SQL developer could refactor a CTE query to a subquery format. LIkewise for people that are trying to modernise old queries with for example 10 levels deep of subquery it would be great to be able to convert these directly to a CTE query.