Getting a list of VALUES rather than CLASSES in sqlalchemy

Question

This problem seems very simple, but I'm having trouble finding an already existing solution on StackOverflow.

When I run a sqlalchemy command like the following

valid_columns = db.session.query(CrmLabels).filter_by(user_id=client_id).first()

I get back a CrmLabels object that is not iterable. If I print this object, I get a list

[Convert Source, Convert Medium, Landing Page]

But this is not iterable. I would like to get exactly what I've shown above, except as a list of strings

['Convert Source', 'Convert Medium', 'Landing Page']

How can I run a query that will return this result?

Answer 1

Below change should do it:

valid_columns = (
    db.session.query(CrmLabels).filter_by(user_id=client_id)
    .statement.execute()  # just add this
    .first()
)

However, you need to be certain about the order of columns, and you can use valid_columns.keys() to make sure the values are in the expected order.

Alternatively, you can create a dictionary using dict(valid_columns.items()).