SQLite Forum

Are there any plans / chances of supporting a RETURNING clause?
Login
I would point out that your argument goes directly against the "authoritative source" principle.  The "authoritative source" of truth is the persistent datastore, not the copy of it that you happen to have in memory.

You must be prepared to deal with the fact that your copy may not be consistent with the "authoritative source" of truth and most efficient way to do that is to not have a copy which you have to continually ensure is consistent with the "authoritative source".

If you do choose to maintain a copy of the "authoritative source" for your use, you should be prepared to keep it consistent with the actual "authoritative source" and not with some proxy therefore.