mode:delete introduction

default table clearing is truncate, introduced mode:delete for a 'soft delete' that does not interfere with wrapping in transactions