logically deleted records are by default skipped, but can be included using include_deleted option to new