comment on

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....)

In reply to Re: Re: Is there a module to generate SQL queries? by rrwo
in thread Is there a module to generate SQL queries? by rrwo

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.


Come for the quick hacks, stay for the epiphanies.
	PerlMonks