Create or Manipulate directly the SQL produced by Discoverer User Edition

In Discoverer User Edition (Desktop, Plus, Viewer) it is not possible to alter directly the SQL produced. The query is dynamically created from Discoverer, depending on items, joins, condition, calculation ... selected during the workbook creation.

The only chance I see here is to create a custom folder in Discoverer Administrator and then create a workbook based on it:

"Custom folders are folders based on a SQL statement which could include SET operators (e.g. UNION, CONNECT BY, MINUS, INTERSECT) or a synonym that you type directly into a dialog.

By defining a custom folder, you can quickly create a folder that represents a complicated result set. When you save the custom folder, Discoverer Administrator creates items using the 'Select' part of the SQL statement you have entered.

In Discoverer Plus, there is no distinction between a custom folder and a simple folder. A Discoverer end user can use a custom folder to build queries in the same way as any other type of folder."

Extracted from :
Oracle® Business Intelligence Discoverer Administration Guide
10g Release 2 (10.1.2.1)
Chapt. 6 Creating and maintaining folders
-- What are custom folders?
(http://download.oracle.com/docs/html/B13916_04/folders.htm#sthref318)