selecting from a subquery in sqlalchemy

[Jonathan Vanasco]

does anyone have a good reference for this ?

i'm trying to select 

    Table.Column , count(Table.Column)

however I'm not querying the Table, instead the raw sql is more like

     SELECT a , COUNT(a) FROM ( SELECT FROM TABLE ) AS sq1

i've never had to select from a subquery in sqlalchemy before.  I can't wrap my head around this and I can't find relevant docs 

[Audrius Kažukauskas]

Something like the following should do the trick:

subq = db_session.query(Model1.field1).\
filter(Model1.field2 == 'bar').subquery()
q = db_session.query(subq.c.field1, func.count(subq.c.field1)).\
group_by(subq.c.field1)

You may want to look at
http://docs.sqlalchemy.org/en/rel_0_8/orm/tutorial.html#using-subqueries
for more examples and explanations.

--
Audrius Kažukauskas
http://neutrino.lt/

[Jonathan Vanasco]

ah, it was in the tutorial

thanks so much!