can not set sa_column_kwargs={"ondelete": "CASCADE"} on foreign_key on many side of one-to-many relationship

[copdips]

First Check

• I added a very descriptive title here.
• I used the GitHub search to find a similar question 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

# https://github.com/tiangolo/sqlmodel/issues/213#issuecomment-1013425005

# SQLite specific
from sqlalchemy.engine import Engine
from sqlalchemy import event
from sqlite3 import Connection as SQLite3Connection


@event.listens_for(Engine, "connect")
def set_sqlite_pragma(dbapi_connection, connection_record):
    if isinstance(dbapi_connection, SQLite3Connection):
        cursor = dbapi_connection.cursor()
        cursor.execute("PRAGMA foreign_keys=ON")
        cursor.close()

# Update models
class Hero(SQLModel, table=True):
    id: Optional[int] = Field(default=None, primary_key=True)
    tests: List["Test"] = Relationship(
        sa_relationship_kwargs={
            "cascade": "all, delete",  # Instruct the ORM how to track changes to local objects
        },
    )


class Test(SQLModel, table=True):
    id: Optional[int] = Field(default=None, primary_key=True)
    hero_id: Optional[int] = Field(
        sa_column=Column(Integer, ForeignKey("hero.id", ondelete="CASCADE"))  # Set the foreign key behavior on the table metadata
    )

Description

The above example is from this issue:
#213 (comment)

When specifying the ondelete cascade at one-to-many's one side (here the Hero class), with sa_relationship_kwargs, it's working, and ORM can handle the cascade delete well.

tests: List["Test"] = Relationship(
    sa_relationship_kwargs={
        "cascade": "all, delete", 
    },
)

But if I tried to defined the ondelete cascade at one-to-many's many side to enable the SQL level cascade delete (here the Test class), with sa_column_kwargs, it doesn't work any more:

hero_id: int | None = Field(
    default=None,
    foreign_key="hero.id",
    sa_column_kwargs={
        "ondelete": "CASCADE",
    },
)

with error:

  File "/home/xiang/git/fastapi-demo/.venv/lib/python3.11/site-packages/sqlmodel/main.py", line 474, in __new__
    col = get_column_from_field(v)
          ^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/xiang/git/fastapi-demo/.venv/lib/python3.11/site-packages/sqlmodel/main.py", line 661, in get_column_from_field
    return Column(sa_type, *args, **kwargs)  # type: ignore
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/xiang/git/fastapi-demo/.venv/lib/python3.11/site-packages/sqlalchemy/sql/schema.py", line 2152, in __init__
    self._extra_kwargs(**dialect_kwargs)
  File "/home/xiang/git/fastapi-demo/.venv/lib/python3.11/site-packages/sqlalchemy/sql/schema.py", line 2234, in _extra_kwargs
    self._validate_dialect_kwargs(kwargs)
  File "/home/xiang/git/fastapi-demo/.venv/lib/python3.11/site-packages/sqlalchemy/sql/base.py", line 596, in _validate_dialect_kwargs
    raise TypeError(
TypeError: Additional arguments should be named <dialectname>_<argument>, got 'ondelete'

But if we used the above issue's method, by using sa_column, it's working.

hero_id: Optional[int] = Field(
        sa_column=Column(Integer, ForeignKey("hero.id", ondelete="CASCADE")) 
    )

Cannot find any information about sa_column_kwargs, maybe it's not supported at all, but as we have sa_relationship_kwargs for one side, I suppose we should have also sa_column_kwargs for many side ?

Operating System

Linux, Windows

Operating System Details

Windows WSL

SQLModel Version

0.0.16

Python Version

Python 3.11.7

Additional Context

No response