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.