I agree with footpad, that this is a data problem.
In Oracle, and especially for Data Warehousing, there is the concept of "Materialized Views" which is an attempt to solve this problem, partway between coding actual tables to hold queries and still allowing the users to enter any query they please. The (potentially) very long execution times for certain queries makes this a valuable approach, especially when the underlying data doesnt change very quickly (materialized views can be refreshed, but in my experience, the time cost is => original query).
Certain front end tools (like Brio) do have varying user levels as well, so that less experienced users have a set of canned queries to choose from (and these are stored in the Oracle database behind it), and the more experienced may enter their own queries.
This approach gives the kind of control a DBA craves, while still allowing a modest level of freedom for users.

In reply to Re: Eliminating Dynamic SQL Generation with Decision Matrices for Tighter Large Scale Applications by poqui
in thread Eliminating Dynamic SQL Generation with Decision Matrices for Tighter Large Scale Applications by princepawn

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.