Is there any command to ignore empty values when updating the database?

Whenever you call update(); of Session, it will also update the null values found in the object.

Example:



The DB will now update the user, but will set the user firstname to null (because it is null in the object).
Is there any way to avoid this? that it will ignore the null value?

I am temporarely fetching the user from the DB now and filling the object with already existing values, but this is one select statement to much tbh.

Thanks

Noone knows?
I see that a custom update query would do the trick but that would require alot more work

I need to resolve same problem. Did u find any solution for that?
Or how can resolve that situation?
I need to restrict, only i need, some properties to be updated. So i can't set "updatable=false".
One idea it's to set property to null value. When it's update executed, that property is ignored, but how do that?