NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.
All the Perl that's Practical to Extract and Report
help them think they understand.
--Larry Wall
Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.
I recommend you take a look at ORLite (Score:2)
I created ORLite to address precisely the problem you are talking about.
ORLite tries to use as little abstraction as possible, and in particular there is no abstraction of where clauses.
my @objects = ORLite::TableName->select( 'END_SQL', 'Bob' );
where name in (
select name from people where husband in (
select name from people where name like ?
)
)
END_SQL
Reply to This