more useful options | |
PerlMonks |
Re: Module for substituting complex criteria into hand-written SQL queriesby 1nickt (Canon) |
on Apr 16, 2017 at 17:31 UTC ( [id://1188055]=note: print w/replies, xml ) | Need Help?? |
Check out SQL::Abstract::More, which extends the parent class with more flexible functionality (and uses named params, Blessed Be!) So you can do something like: Output: As you can see this SQL builder often adds unnecessary parentheses; I don't worry about these since any decent RDBMS will optimize them away. update: added example and then example output Hope this helps!
The way forward always starts with a minimal test.
In Section
Seekers of Perl Wisdom
|
|