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

I am working in a pyramid project and I’ve the table in SQLAlchemy in declarative syntax

class Projects(Base):
    __tablename__ = 'projects'
    __table_args__ = {'autoload': True}

I get the results by using

session = DBSession()
row_data = session.query(Projects).filter_by(id=1).one()

How can I get the column names from this result.

PS: I am unable to use this method since I am using the declarative syntax.


The difference is between ORM and non-ORM, not declarative, which is just a helper for the ORM.

Query has a method column_descriptions() that was added for this purpose::

the example there seems like it has a typo, says q.columns but it should be q.column_descriptions (edit: just fixed it).

Related Posts

© No Copyrights, All Questions are retrived from public domain.
Tutorial Guruji