converting to json would be like this:

   for row in rows:
      converted = json.dumps(row)

it is possible that your json encoder can not handle a particular 
sqlalchemy object.  if that is the case you will need to build your own 
json dumps function or encoder that can adapt your data.  flask's encoder 
is a good starting point:

SQLAlchemy - 
The Python SQL Toolkit and Object Relational Mapper

To post example code, please provide an MCVE: Minimal, Complete, and Verifiable 
Example.  See for a full description.
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
To post to this group, send email to
Visit this group at
For more options, visit

Reply via email to