added all sql processing methods