How can we use with_entities while using databases library?

[MilanRgm]

What is the alternative for this query while using this library?

query = User.query
query.with_entities(User.email, User.id).all()

[aminalaee]

This should work:

query = User.select().with_only_columns([User.c.email, User.c.id])

results = await database.fetch_all(query=query)

https://docs.sqlalchemy.org/en/14/core/selectable.html#sqlalchemy.sql.expression.Select.with_only_columns