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.