This came up while working on datasette-sqlite-history-json:

• Add design document for user-scoped change groups datasette/datasette-sqlite-history-json#2

The desire was to run some custom SQL before and after any write operations, depending on the current request and actor.

Claude helpfully wrote a design document for this which made a solid case for a new plugin hook that wraps writes to the database: https://github.com/datasette/datasette-sqlite-history-json/blob/38360848cc0458ca339c77a92de98ef25f84ec3b/docs/design-change-groups.md