add bulk methods & fixed some sql2object casts