__table_args__ not populated / custom dialect / timescale db

[fellnerse]

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

from sqlalchemy import MetaData
from sqlmodel import SQLModel


class RawDataBase(SQLModel):
    metadata = MetaData(
        schema="raw_data",
    )

class CustomModel(RawDataBase, table=True):
    __table_args__ = (
        {
            "timescaledb_hypertable": {"time_column_name": "time", "chunk_time_interval": "2 days"},
        },
    )

Description

Hey,
I'm using a custom timescaledb dialect similar to this: https://github.com/dorosch/sqlalchemy-timescaledb
And it works flawlessly in SQLAlquemy. I would like to transition now to SQLModel, but was not able to find a way of also replicating this here.

With SQLAlquemy the resulting DDL looks similar to this:

    op.create_table(
        "custom_model",
        ...
        schema="raw_data",
        timescaledb_hypertable={"time_column_name": "time", "chunk_time_interval": "2 days"},
    )

But when I do the same with SQLModel, the timescaledb_hypertable argument is not passed on, and it looks like this:

    op.create_table(
        "custom_model",
        ...
        schema="raw_data",
    )

I would like to continue use the autogenerated migrations. What am I doing wrong? I experimented with custom Constraints, but none of them end up in the create table operation. What is the correct way of doing this? Thanks in advance!

Operating System

macOS

Operating System Details

No response

SQLModel Version

0.0.24

Python Version

Python 3.12.8

Additional Context

No response