Re: [sqlalchemy] how to use postgresql json type in sql expression language

2015-12-11 Thread Mike Bayer
All SQL operators are agnostic of the ORM, docs for the JSON type and examples of its special operators are at: http://docs.sqlalchemy.org/en/rel_1_0/dialects/postgresql.html?highlight=json#sqlalchemy.dialects.postgresql.JSON On 12/11/2015 03:34 AM, kk wrote: > Dear all, > I am using Postgresql

[sqlalchemy] how to use postgresql json type in sql expression language

2015-12-11 Thread kk
Dear all, I am using Postgresql for the data and in some tables there is the json type field. It may often have float values and keys as strings. I don't use ORM very often but love using the sql expression api of alchemy. I wonder if there is some syntax for accessing json type without using O