There's a restriction in prisma update, I cannot set a nullable foreign key column to null? When i try to directly set the foreign key to any value it throws an error say i need to basically access the field relation and not the key i.e using connect. However, I cannot use connect and pass in a null id, so i instead added a conditional checking if the foreign key id is not null, if so use connect to update the value using the id, otherwise return null. However returning null does not update the value to null. Raised issue
https://github.com/prisma/prisma/issues/2324