- (Object) select_all(sql, name = nil) Returns an array of record hashes with the column names as keys and column values as values.
- (Object) select_one(sql, name = nil) Returns a record hash with the column names as keys and column values as values.
- (Object) select_rows(sql, name = nil) Returns an array of arrays containing the field values.
- (Object) select_value(sql, name = nil) Returns a single value from a record.
- (Object) select_values(sql, name = nil) Returns an array of the values of the first column in a select:.
via rdoc.info
Good stuff if you're feeling like a SQL wizard