How to get column names from SQLAlchemy result (declarative syntax)

by

You can do something similar to Foo Stack’s answer without resorting to private fields by doing:

conn.execute(query).keys()

More Related Contents:

  1. sqlalchemy existing database query
  2. SQLAlchemy printing raw SQL from create()
  3. How to serialize SqlAlchemy result to JSON?
  4. SQLAlchemy: print the actual query
  5. SQLAlchemy create_all() does not create tables
  6. Query for list of attribute instead of tuples in SQLAlchemy
  7. How do I get a raw, compiled SQL query from a SQLAlchemy expression?
  8. SQL Alchemy ORM returning a single column, how to avoid common post processing
  9. How do I execute inserts and updates in an Alembic upgrade script?
  10. SQLAlchemy, get object not bound to a Session
  11. Python call sql-server stored procedure with table valued parameter
  12. Generate sql with subquery as a column in select statement using SQLAlchemy
  13. Bulk insert with SQLAlchemy ORM
  14. How can I verify Column data types in the SQLAlchemy ORM?
  15. Flask sqlalchemy many-to-many insert data
  16. How to delete a record by id in Flask-SQLAlchemy
  17. Connection problems with SQLAlchemy and multiple processes
  18. How to upsert pandas DataFrame to Microsoft SQL Server table?
  19. How do I select literal values in an sqlalchemy query?
  20. Get inserted key before commit session
  21. SQLAlchemy multiple foreign keys in one mapped class to the same primary key
  22. SQLAlchemy: engine, connection and session difference
  23. Relations on composite keys using sqlalchemy
  24. flake8 complains on boolean comparison “==” in filter clause
  25. SQLAlchemy – Mapping self-referential relationship as one to many (declarative form)
  26. SQLAlchemy: get Model from table name. This may imply appending some function to a metaclass constructor as far as I can see
  27. pandas to_sql all columns as nvarchar
  28. How to make mysql connection that requires CA-CERT with sqlalchemy or SQLObject
  29. Can’t change system default SQLite binary
  30. add column to SQLAlchemy Table

Leave a Comment