Re^2: What's your favorite SQL generation module?

[perrin]

I have data from a form that has to be turned into a select statement and it has too many options to write out every possibility, so there is no other option but to generate SQL to some degree. Since I'm only looking for something to create the actual SQL, not to handle any of the DBI work, transaction management will be up to me.

[santonegro]

Since no-one has mentioned DBIx::Class and its powerful synergy with SQL::Abstract (a good SQL generator on its own), I now mention it. Jesse Vincent's DBIx::SearchBuilder is heavily used. And we can't forget DBIx::Recordset for a change in approach, though I am not happy with what happened to all my bugfixes to it. qw

[perrin]

Thanks for the suggestions. I looked at DBIx::Class, but it doesn't seem to have encapsulated the SQL generation into a single piece that can be used without the rest of it. SQL::Abstract is okay for WHERE clauses but can't handle anything fancy, particularly joins. DBIx::SearchBuilder bears looking into. At first glance it seems like it wants to the DBI part too though, which would disqualify it. DBIx::Recordset always put me off with its syntax, but I'll give that another look too.