http://qs321.pair.com?node_id=553926

perrin has asked for the wisdom of the Perl Monks concerning the following question:

I have a need for a module that will generate very complex SQL based on a search spec. This will include things like left joins and subqueries. I'm looking for recommendations on CPAN modules that will give me a head start.

Note that I am not looking for an object-relational mapper here. I just want to generate SQL.

UPDATE: After checking out the suggestions here and looking through CPAN results for SQL and DBIx, it's coming down to a decision between SQL::Interpolate and Rose::DB::Object::QueryBuilder.