sqlalchemy - query.all() - list of tuples to dict

Question

This is my call: session.query(User.username, User.first_name, User.last_name).all()

It returns: [('myUsername', 'myFirstname', 'myLastname')].

I want that to be the following format:
[{"username":"myUsername", "first_name":"myFirstname", "last_name":"myLastname"}]

I tried with [dict(zip(["username","first_name","lastname"], x))]
But it returns this: [{'username': ('myUsername', 'myFirstname', 'myLastname')}]

Answer 1

row = session.query(User.username, User.first_name, User.last_name).all()
as_dict = dict(zip(row.keys(), row))