Hi all,

Sorry if I repeat a question that was already asked, I couldn't find 
anything to help me out. I'm trying to build a SELECT statement for a table 
which has a JSON field.

For brevity I include only the essentials.
class User(Base):
   id = Column(Integer)
   data = Column(JSON)

session.query(User.data["name"].astext == "admin").all()

Unfortunately this generates an SQL query which will put "name" in 
double-quotes like this
'"name"'

What am I doing wrong?

Vlad

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.

Reply via email to