Returning as dict

[JosephShering]

I would really like it if object were returned instead of dictionaries, it would make looping over the results a lot easier

[ToffeeCrunch]

What do you mean? Could you give an example of what you would like and how it looks now?

[pudo]

+1 on @ToffeeCrunch's suggestion. We can probably have a constructor argument where you pass in a class that overrides getattr, is that what you mean?

[sbirch]

This would also be nice to support indexing the columns in order (with a different kind of class, of course). Right now AFAIK it's not possible to know what the original key order is.

[gka]

@sbirch that would be possible by returning OrderedDicts instead of dicts.. Actually a good idea I think.

[gka]

OrderedDict support added in branch ordered-dicts

[sbirch]

Woohoo! That will be very useful to me. Though I still think there's value in @JosephShering's original suggestion, as it provides the flexibility to do things like what you did without forking it. (Attribute accessors would be very nice too, for example.)

[stefanw]

FYI: right now SQLAlchemy's RowProxy objects are returned that mostly behave like ordered dicts.

[pudo]

It's OrderedDict now.