Dallaylaen has asked for the wisdom of the Perl Monks concerning the following question:
Hello dear esteemed monks,
Sometimes I wish I could do something along the lines of
my $sth = $dbh->prepare("SELECT f.bar, f.baz FROM foo f WHERE f.???"); $sth->execute({ bar => 42});
I.e. pass a hash instead of individual values (thus ??? instead of just ? for 1 value). Also I want to be able to write
{ var => (value > 5) & (value <= 10) }
instead of a single value, specifying a complex criteria that would unfold into a proper WHERE statement (or part of it).
I was able to create a prototype module implementing (to some extent) the latter and minimally the former. However, maybe there's an already existing solution on CPAN? The size of DBIx:: namespace is far beyond my comprehension, so I seek help here.
Looks like SQL::Abstract does something similar... Are there more precise matches? And yes, I love the ability to write SQL queries by hand (or ask a DBA to), it's just substitution of criteria that I find inconvenient.
Thank you, and hope you have a nice day!