[sqlalchemy] Fetching custom-type columns as native types

2012-12-17 Thread Burak Arslan
Hi, I have a column of type PGObjectXml. (https://github.com/arskom/spyne/blob/ed574564383ff8cc757cd4609eede6d049c9b574/spyne/util/sqlalchemy.py#L184) What is the best way of replacing the designated column type temporarily just for a select query? E.g. How do I fetch the column as a simple

Re: [sqlalchemy] Fetching custom-type columns as native types

2012-12-17 Thread Michael Bayer
type_coerce() does this on a per-statement basis: http://docs.sqlalchemy.org/en/rel_0_8/core/expression_api.html?highlight=cast#sqlalchemy.sql.expression.type_coerce it's fairly recent and has had some fixes that are 0.8 only. On Dec 17, 2012, at 4:48 PM, Burak Arslan wrote: Hi, I have a