I think the dynamic creation of SQL is used if flexibility
is required. If the queries are always the same it would be
enough to store them in a list or hash and then access them
I worked on a concept once where all the SQL would be stored
in a file like so:
%sql_queries = (
  1 => qq~SELECT blah FROM blah WHERE id = ?~,
  2 => qq~SELECT blah,more_blah FROM blah WHERE id = ? and name = ?~,
);

[download]
Then for development the programmers would refer to the
hash and then access the right SQL them via the correct key.
Now this was just an idea that was tossed around and no real
project was developed with it, but the idea brings to point
the rules you talk about in order to "choose" the right query.
I would be interested in seeing your idea of how a "rules" file
would be structured for something like this.

In reply to Re: Eliminating Dynamic SQL Generation with Decision Matrices for Tighter Large Scale Applications by trs80
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.