Rose::DB::Object::QueryBuilder set operations

Hi,

I'm looking at using Rose::DB::Object::QueryBuilder on its own (without 
the rest of RDBO) to generate some SQL.  It looks like this should work 
fine.  However, I'm finding the in_set and in_array methods very confusing.

According to the docs, 'COLUMN' => { in_set => 'A' } generates the SQL 
"A IN COLUMN".  This seems like the reverse of normal usage, e.g. "name 
IN ('john','paul')".  Can anyone explain what this might be used for?

Also, what is the difference between "IN" (in_set) and "= ANY" 
(in_array)?  According to all the database docs I've seen, these are 
equivalent.

Were these meant to be used for subqueries?  I do intend to work with 
subqueries and am thinking about how to incorporate them or else cheat 
with some post-processing.

- Perrin