Fix sqlmodel field being overide by pydantic

fastapi · stickm4n · Oct 11, 2025 · Oct 11, 2025 · Oct 11, 2025 · Oct 11, 2025
commit 66e1bfe3d1db2e502416897e32e3fd444d28bc47
diff --git a/sqlmodel/main.py b/sqlmodel/main.py
@@ -562,7 +562,14 @@ def get_config(name: str) -> Any:
             # If it was passed by kwargs, ensure it's also set in config
             set_config_value(model=new_cls, parameter="table", value=config_table)
             for k, v in get_model_fields(new_cls).items():
-                col = get_column_from_field(v)
+                original_field = getattr(v, "_original_assignment", Undefined)
+                annotated_field_meta = new_cls.__annotations__[k].__dict__.get("__metadata__", [])
+                annotated_field = next((f for f in annotated_field_meta if isinstance(f, FieldInfo)), None)
+                field = original_field if isinstance(original_field, FieldInfo) else (annotated_field or v)
+                # Get the original sqlmodel FieldInfo, pydantic >=v2.12 changes the model
+                field.annotation = v.annotation
+                # Guarantee the field has the correct type
+                col = get_column_from_field(field)
                 setattr(new_cls, k, col)
             # Set a config flag to tell FastAPI that this should be read with a field
             # in orm_mode instead of preemptively converting it to a dict.