In SQLAlchemy how do I preview SQL statements before committing for debugging purposes?

Question

I want to see the SQL code instead of doing an actual db.commit(). This is for a one-off database population script that I want to verify is working as intended before actually making the changes.

Answer 1

Try calling str() on the query object.

print query_object.str()

From:

How do I get a raw, compiled SQL query from a SQLAlchemy expression?

Other possible solutions:

• SQLAlchemy: print the actual query
• How to retrieve executed SQL code from SQLAlchemy

The newest (as of v0.9) answer is also:

• Retrieving ultimate sql query sentence (with the values in place of any '?') (by Mike Bayer)