Is it possible to update schema once created?

[perfecto25]

First Check

• I added a very descriptive title to this issue.
• I used the GitHub search to find a similar issue and didn't find it.
• I searched the SQLModel documentation, with the integrated search.
• I already searched in Google "How to X in SQLModel" and didn't find any information.
• I already read and followed all the tutorial in the docs and didn't find an answer.
• I already checked if it is not related to SQLModel but to Pydantic.
• I already checked if it is not related to SQLModel but to SQLAlchemy.

Commit to Help

• I commit to help with one of those options 👆

Example Code

class Xconnect(SQLModel, table=True):
    id: int = Field(primary_key=True)
    lvc: Optional[str] = Field(sa_column_kwargs={"unique": True})
    customer: int = Field(foreign_key="customer.id")
    region: int = Field(foreign_key="attr.id")

Description

Im trying to see if I can update the exisitng generated table Xconnect without deleting and recreating it,

for example, if I wantto make the Region field Optional, adding

region: Optional[int]

will not update the existing schema bcs the table is already created. How can I update the existing schema? Do I need to use Alembic for this?

Operating System

Linux

Operating System Details

linux mint 19

SQLModel Version

0.0.5

Python Version

3.8

Additional Context

No response

[voxofox]

As you've mentioned, Alembic would be a good solve.