Is there a way to support alternate column names?

[n8henrie]

I have a table that I'm trying to adapt from sqlalchemy in which a column name is a Python keyword (open). In my sqlalchemy table, I use open_ = Column("open", Float) so as to avoid overriding the keyword.

In my orm.Model, I'm unable to find a way to have an equivalent mapping of the mymodel.open_ object.

I tried open_ = orm.Float(name="open") but that isn't a supported kwarg.

open_ = orm.Float(title="open") doesn't work, resulting in asyncpg.exceptions.UndefinedColumnError: column tiingo_daily_historical.open_

Am I overlooking a way to do this?

Many thanks in advance!

[aminalaee]

With orm version 2 this is possible:

class Note(orm.Model):
    tablename = "notes"
    registry = models
    fields = {
        "id": orm.Integer(primary_key=True),
        "text": orm.String(max_length=100),
        "completed": orm.Boolean(default=False),
    }