We can't immediately add to the cache if we have formulas which must be evaluated, or if we have the possibility of two concurrent updates to the same item being merged on the database. This can happen if (a) the item is not versioned and either (b) we have dynamic update enabled or (c) we have multiple tables holding the state of the item.

The queries that delete rows by id (and version)

The query that inserts a row, letting the database generate an id

The queries that insert rows with a given id

The queries that update rows by id (and version)