comment on

I think you're making too much work for yourself, someone has already done it for you.
I highly recommend SQL:Abstract

The rest is shamelessly ripped from module the docs:

This module can generate pretty complicated WHERE statements easily. For example, simple key=value pairs are taken to mean equality, and if you want to see if a field is within a set of values, you can use an arrayref. Let's say we wanted to SELECT some data based on your criteria:

use SQL::Abstract;
    my $sql = SQL::Abstract->new;
    
    my %where = (
       name => 'smith',
       salary => {'>', 50000},
       department => { 'not like', 'eng%' }
    );


    my($stmt, @bind) = $sql->select($table, *, \%where, \@order);
[download]

This module also handles insert, update and delete, as well as ORing and ANDing your conditional clauses

--
Clayton

In reply to Re: How do Monks programatically construct SQL selects by clscott
in thread How do Monks programatically construct SQL selects by Cody Pendant

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


Perl-Sensitive Sunglasses
	PerlMonks