I haven't talked about transactions yet, but Sequel probably has the best transaction support of all the ruby database libraries.