How to retrieve python list of SQLAlchemy result set? [duplicate]

the most succinct way to pull out a list of 1-element tuples into a list is:

result = [r[0] for r in result]

or:

result = [r for r, in result]