Hello, does any one know if there is a way in prisma to only allow update a field only when it is empty? The use case is like timestamp for

createdAt

, I want to ensure the value is locked.

@Leo Li 👋 I don’t think you can directly do it in a single query but you can use interactive transactions for this use case.

@Ryan thanks, I ended up writing a DB trigger for that use case