SQLite Forum

Are there any plans / chances of supporting a RETURNING clause?
Login
You fail to understand.  Just because you deleted something does not mean that it is the only change to the "tree view" control.  Nor does it mean that the nanosecond after you deleted something, it was not added again by someone else.

The only way to obtain accurate results *unless the database is single-user by the application and all other applications are precluded from making changes to the database* is to re-read the database and make the "tree view" control consistent with the "authoritative source".

Otherwise, the "tree view" is merely a whimsy and not reflective of any actual state of affairs that actually existed at any point it time.