using sqlalchemy class models to generate queries

[nbraun-wolf]

Hi, I am wondering how sqlalchemy model classes could be used to get a query to execute. In the example, the Table class is used.

notes = sqlalchemy.Table(...)
query = notes.insert()
values = {"text": "example1", "completed": True}
await database.execute(query=query, values=values)

But I am looking to do something like this from my model classes.

class User(Model):
    ...

Is there a way of doing that?

[aminalaee]

Hey, I think with SQLAlchemy 1.4 this should work:

from sqlalchemy import select

query = select(User).where(User.name == 'spongebob')
await database.execute(query)

[nbraun-wolf]

Yes that works. Thank you :) We just need to convert query to string it seems.

await database.execute(str(query))