in reply to Re: Is there a module to generate SQL queries?
in thread Is there a module to generate SQL queries?
Thanks, but DBIx::RecordSet is definitely what I'm not looking for. DBIx::SearchBuilder looks nice, but like the former it does too much.
I just want to create the SQL query, and then pass the parameters to the bindings. But I still want a statement handle to do what I will with.
An aside: DBIx::SearchBuilder seems poorly documented, and specific to certain databases.
Gripe: I can't stand it when there are modules that try to do everything (A+B+C), when I need a module to do A or B only, because I'm trying to do A+B+D instead. I do wish module authors would break up their modules into modules with distinct useful functions (i.e., SQL statement generation, statement handle searches, and then maybe a recordset add-on as all separate modules). It forces one to write portions of this from scratch! (Guess I'll E-mail the author about this....)