When the table model was created, the max_length attribute of Field did not take effect

[HuoWenBo]

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 typing import Optional

from sqlmodel import SQLModel, Field, create_engine

engine = create_engine('sqlite:///database.db', echo=True)


class User(SQLModel, table=True):
    id: Optional[int] = Field(primary_key=True)
    name: str = Field(max_length=64)
    email: str = Field(max_length=32)


SQLModel.metadata.create_all(engine)

Description

I don't speak English well, please forgive me.
This above code gets:

CREATE TABLE user (
        id INTEGER NOT NULL,
        name VARCHAR NOT NULL,
        email VARCHAR NOT NULL,
        PRIMARY KEY (id)
)

I want to get it:

CREATE TABLE user (
        id INTEGER NOT NULL,
        name VARCHAR(64) NOT NULL,
        email VARCHAR(32) NOT NULL, 
        PRIMARY KEY (id) 
)

I have to use sa_type=VARCHAR(x) to get the desired effect

Operating System

Windows

Operating System Details

No response

SQLModel Version

0.0.16

Python Version

3.9

Additional Context

No response