How do I see the column names of a joined table in SQLAlchemy?

Question

I created a table using join()

q = db_session.query(Email).join(Candidate)

Is there a way to print out either the contents of q or the columns?

Answer 1

Sure, .join() produces a new Query object which you can inspect via .column_descriptions and .statement:

print(q.column_descriptions)
print(q.statement)

There is more to how you can inspect the query, please see:

• SQLAlchemy: print the actual query