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

by

This blog provides an updated answer.

Quoting from the blog post, this is suggested and worked for me.

>>> from sqlalchemy.dialects import postgresql
>>> print str(q.statement.compile(dialect=postgresql.dialect()))

Where q is defined as:

>>> q = DBSession.query(model.Name).distinct(model.Name.value) \
             .order_by(model.Name.value)

Or just any kind of session.query().

Thanks to Nicolas Cadou for the answer! I hope it helps others who come searching here.

More Related Contents:

  1. How to execute raw SQL in Flask-SQLAlchemy app
  2. Not all parameters were used in the SQL statement (Python, MySQL)
  3. pip install mysqlclient returns “fatal error C1083: Cannot open file: ‘mysql.h’: No such file or directory
  4. How to disable SQLAlchemy caching?
  5. memory-efficient built-in SqlAlchemy iterator/generator?
  6. Writing to MySQL database with pandas using SQLAlchemy, to_sql
  7. sqlalchemy: how to join several tables by one query?
  8. How to build a flask application around an already existing database?
  9. Using a Python dict for a SQL INSERT statement
  10. SQLAlchemy ON DUPLICATE KEY UPDATE
  11. Python, SQLAlchemy pass parameters in connection.execute
  12. Bulk insert with SQLAlchemy ORM
  13. Insert list into my database using Python [duplicate]
  14. Python Pandas write to sql with NaN values
  15. Complex foreign key constraint in SQLAlchemy
  16. ImportError: No module named MySQLdb
  17. How to get rows which match a list of 3-tuples conditions with SQLAlchemy
  18. Dynamic SQL Queries with Python and mySQL
  19. SQLAlchemy: how to filter date field?
  20. flake8 complains on boolean comparison “==” in filter clause
  21. How to execute “left outer join” in SqlAlchemy
  22. Getting random row through SQLAlchemy
  23. Select NULL Values in SQLAlchemy
  24. python pandas to_sql with sqlalchemy : how to speed up exporting to MS SQL?
  25. SQLAlchemy Obtain Primary Key With Autoincrement Before Commit
  26. Reverse engineer SQLAlchemy declarative class definition from existing MySQL database?
  27. How to make mysql connection that requires CA-CERT with sqlalchemy or SQLObject
  28. Retrieve query results as dict in SQLAlchemy
  29. VALUES clause in SQLAlchemy
  30. flask sqlalchemy query with keyword as variable

Leave a Comment