I have used update_hooks to achieve similar behaviour in my projects. But perhaps this is intended as a higher level layer? It looks like the implementation is not using hooks?

https://sqlite.org/c3ref/update_hook.html