use mark_as_soft_deleted_sql when mass-deleting
v0.5.5