How to add dialect specific index (postgres)?

[fishfacegit]

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 sqlmodel import Field, SQLModel, Column
from sqlalchemy import Text, Index
import datetime


class Hero(SQLModel, table=True):
    date_of_birth: datetime.date = Field(nullable=False, primary_key=True)
    universe_time: datetime.datetime
    likes_banana: bool = Field(nullable=True, index=Index('ix_hero_likes_banana', 'likes_banana', postgresql_using='hash'))
    name: str = Field(sa_column=Column(Text()))

Description

The likes_banana index is using BTREE, not HASH type.
How can i define the index properly using dialect specific indices like hash, btree, gin, and gist?

Operating System

Linux

Operating System Details

No response

SQLModel Version

0.0.8

Python Version

Python 3.10.6

Additional Context

No response

[fishfacegit]

Defining the index via SQLAlchemy separate from class will do the trick.

from sqlmodel import Field, SQLModel, Column
from sqlalchemy import Text, Index
import datetime


class Hero(SQLModel, table=True):
    date_of_birth: datetime.date = Field(nullable=False, primary_key=True)
    universe_time: datetime.datetime
    likes_banana: bool = Field(nullable=True)
    name: str = Field(sa_column=Column(Text()))

Index('ix_hero_likes_banana', Hero.likes_banana, postgresql_using='hash')