supports limit/offset and fix for update & dirtyness