python - SQLAlchemy: Convert nested query set into dict -

im fetching nested dataset using following query:

users = db.query(user).options(subqueryload(user.orders)) 

i want turn result dict. method i'm using is:

for user in users:     user.__dict__ 

this approach turns user object dict, nested dataobject (orders) still models.orders object:

{'id: 1l, 'username': "some_username", "orders": [<models.orders object @ 0x10608d90>,<models.orders object @ 0x40107d90>,]} 

how can convert nested data objects dicts?

a generic solution preferable.