Some fields are translated as JSON fields even though they shouldn't be

[iron3oxide]

I have the following setup:

A table base model

class TableBase(BaseModel):
    id: int = Field(default=1, gt=0)
    created_by: str
    created_at: datetime = Field(default_factory=datetime.now)
    last_modified_by: str = Field(default="not_yet_modified")
    last_modified_at: datetime | None = Field(default=None)

and the final tables inheriting from the table base and the respective read model, e.g.:

@db.table(pk="id")
class Language(LanguageRead, TableBase):
    pass

When I call db.init() I get an sqlalchemy ProgrammingError and it shows me the following SQL as the culprit:

CREATE TABLE language (
        id JSON, 
        created_by VARCHAR NOT NULL, 
        created_at JSON, 
        last_modified_by VARCHAR, 
        last_modified_at JSON, 
        name VARCHAR NOT NULL, 
        PRIMARY KEY (id)
)

The issue is probably in PydanticSQLTableGenerator._get_column() but I couldn't figure out why my model fields would be caught by one of the cases specified for JSON there. Any help is appreciated!

[iron3oxide]

One initial observation though: at the moment, there seems to be no way to translate date/datetime fields of any kind to their respective sqlalchemy counterparts, this should be an easy addition.