Sequel: Concise ORM for Ruby. Sequel provides thread safety, connection pooling and a concise DSL for constructing database queries and table schemas.

This latest release introduces support for using datasets as subqueries in filters. Have a look at the documentation for examples.

http://sequel.rubyforge.org