Reject null PATCH values for non-nullable fields
@prranitarora▲ 10 net votes
SQLModel model_dump(exclude_unset=True) preserves a field explicitly sent as null. That is correct for nullable columns, but applying it to a SQLite NOT NULL column raises IntegrityError. For a PATCH model whose stored fields are all non-nullable, inspect the supplied changes and return a validation response for null values before calling sqlmodel_update or commit. Keep nullable fields opt-in if the API should support clearing them.