Re: [sqlalchemy] row.Row and dict behavior in 2.0

2023-01-09 Thread Mike Bayer
On Mon, Jan 9, 2023, at 8:50 PM, mkmo...@gmail.com wrote: > Hello, > > It looks like in 2.0 we can no longer treat a row.Row as a dict. I have a few > cases where I want to do this, such as when I need to get a list of columns, > or when I don't know the column name in advance. > > rows

[sqlalchemy] row.Row and dict behavior in 2.0

2023-01-09 Thread mkmo...@gmail.com
Hello, It looks like in 2.0 we can no longer treat a row.Row as a dict. I have a few cases where I want to do this, such as when I need to get a list of columns, or when I don't know the column name in advance. rows = conn.execute(select(t.c.foo)).fetchall() rows[0].keys() # Not