[Feature Request] Model-Level CRUD Hooks

Is your feature request related to a problem? Please describe.

Prisma's current API for hooks (esp. at model level) is lacking.
- .$extends requires explicit method wrapping, and doesn't support method-level extending.
- Computed fields (which can cover some use-cases of READ hooks) are methods, and therefore unserializable - meaning, they're unable to be passed to the frontend unless explicitly called in the server
Prisma Pulse is the current best solution, but is a separate third-party service (which currently only supports Postgres) and therefore may not be a practical solution for most.
Zenstack's philosophy seems to jibe with locking down actions/logic to the model level, and therefore, thinking about implementing model-level CRUD hooks in the future may be appropriate

Example Usecases:

Create: Famous Instagram-DB use-case of implementing a counter on a model-level field for # of likes as the db history of individual like objects is too big to cache. I.e., creation of Like document would fire a hook that updates their Post document.
Read: Some high-security apps need to keep read logs for everything an employee has accessed.
Update: After updating User model with a membership level, you may want to send the user an email thanking them for purchasing xyz subscription
Delete: cleaning up other model rows that may not be able to directly link to the deleted record for whatever reason

Describe the solution you'd like

Definable-hooks applied at the enhance call, i.e. allowing the user to execute JS based on

Hooks will be fired even if I update a model via a call from a model above/below:

user.update({
data: {
  subscription: {
      create: {
          // etc ... 
      }
  }
}
})

Post-MVP: Hooks would be able to access the prev/post document (or maybe you could have preX, postX hooks? - Post-Post-MVP may allow for pre hooks to cancel an action (pie-in-the-sky, I know ...))
Post-MVP: provider the hook's function params access to the user that made the CRUD request. Useful for implementing read-logs etc.

Potential Challenges:

AFAIK, there isn't an inbuilt API that wraps the Prisma core methods
Determining when a model is CRUD'ed via a parent/children call may be tricky too

Comment from @ymc9

This is some thought background about access conrol. As for CRUD hooks, I fully agree with you that implementing with Prisma client extensions can be quite challenging given the flexibility of nesting - it's very easy to have a leaky implementation. I think it's a good idea that we "reimplement" some kind of hook at the TS-API land, like allowing you to provide simple callbacks when calling enhance (model + operation + action), and the API internally deals with traversing nesting, and probably also guarantees a transaction boundary.

zenstackhq / zenstack

[Feature Request] Model-Level CRUD Hooks #1128