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

Question

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

"""models.py"""
class Projects(Base):
    __tablename__ = 'projects'
    __table_args__ = {'autoload': True}

I get the results by using

""""views.py"""
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.

Answer 1

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

conn.execute(query).keys()