I assume that it is possible to build an APEX App that looks and feels like the internal APEX Query Builder tool, since APEX is supposedly written in APEX. Below is a link to the APEX QUery Builder tool.
SQL Workshop Guide (0 Bytes)If an APEX App were created from this the only differences would be:
I would want the new APEX App to save the user created queries components to tables in my default schema, rather than tables internal to APEX.
I would prefer the saved queries created previous to display on a separate tab at the top of the page, rather than a less noticeable "Saved SQL" tab on the object pane on the lower part of the page.
Has anyone done this or have a ballpark estimate of the effort? Could it be as simple as copying the APEX page shown in the screen shot below, and the associated tables to an APEX App, since it maybe be an internal page 1002 (highlighted in red in url of screenshot)?
