[Spike] : Investigate Prisma Client Extensions (PCE)

[YazeedLoonat]

We want to investigate Prisma Client Extensions (PCE): https://www.prisma.io/docs/orm/prisma-client/client-extensions

what we would like to do is build a custom query (or set of queries) to "update" supporting records as in-place as possible

if we take Listing -> Listing Events as our example:
we want to build a custom extension such that:

• if its a new listing event it gets created in the db
• if its a listing event that is being removed from the db it gets deleted from the db
• if its a listing event that is getting updated then update it in place
• if its a listing event that has no changes, do nothing to it

the way it currently works is we delete all listing events and then re-create them. PCE might be able to reduce that churn and hopefully make the process easier, or at least more legible