It doesn’t have to be. You Can write reads that don’t return entries if a separate deletion entry exists. Can’t say I’ve worked that way in sql, but I have see

It doesn’t have to be. You Can write reads that don’t return entries if a separate deletion entry exists. Can’t say I’ve worked that way in sql, but I have seen that pattern in append only data structures. With for instance a “order fulfilled” entry essentially is a delete operation on an outstanding order entry.