> > from   :c => Customer, :b => Bank, :a => Account
> >   select b.name
> >   where  ((c.firstname == first1) |
> >           (c.firstname == first2)), etc.

> > appeared simpler than having blocks and .AS, but no doubt there is a
> > limit to his approach I'm unaware of.

> Actually for that kind of thing you can specify your filter as a hash:

>   where(:firstname => [first1, first2])

> Notice how you can provide an array and Sequel takes care of
> constructing the filter. Also gives you nicer-looking SQL:

>   ... WHERE firstname IN ('john', 'george')

> If you need to qualify the field name you can use the special symbol
> notation:

>   where(:c__firstname => [first1, first2])

> Sequel also lets you use any comparison operator, not just ==:

>   where {:price > 100}

> You can also specify mathemtic expressions and compare against other
> fields:

>   where {:price < :avg[:price] - 100}

> Have a look at the cheat sheet:

>   http://code.google.com/p/ruby-sequel/wiki/CheatSheet

> sharon