how to connect/insert sqlalchemy orm result to class schema

i want开发者_运维问答 to connect my sqlalchemy orm result to a class schema

class StoreOrderOverallFlat(): id: int pending: int processing: int delivered: int total: int pickup: int delivery: int query = db.select([order.columns.store_id,store.columns.name.label('store_name'),delivery,processing, pickup,delivered,pending,total]).select_from(store.join(order,order.columns.store_id==store.columns.id)).group_by(order.columns.store_id,store.columns.name) `

i dont want it in a table form, i want it to be in class schema