add suppot for limit/offset to all all() methods