SQLAlchemy has had a PG ARRAY type for a few years, and 0.8 now has full expression support including the ability to use regular Python array indexes and slices

SQLAlchemy has had a PG ARRAY type for a few years, and 0.8 now has full expression support including the ability to use regular Python array indexes and slices: select([mytable.c.data[5], mytable.c.data[2:7]]) as well as array literals in expressions: stmt = select([ array([1,2]) + array([3,4,5]) ]) We'll soon be adding hstore (and JSON) to tip as well, right now hstore is available as a separate extension: https://bitbucket.org/audriusk/hstore/src/e0b4f7987ebe/example_orm.py#cl-48 https://bitbucket.org/audriusk/hstore/src/e0b4f7987ebe/examp...