Hm, now it is ok, but previously, during another task, I checked the method and it returned the result with subquery, like this: SELECT a.c FROM (SELECT t.c FROM t) as a
Why did I get the result with subquery? Does it depend on something specific? суббота, 30 апреля 2016 г., 16:05:12 UTC+3 пользователь Mike Bayer написал: > > yes please use query.with_entities > > > http://docs.sqlalchemy.org/en/rel_1_0/orm/query.html?highlight=query.with_entities#sqlalchemy.orm.query.Query.with_entities > > > > On 04/30/2016 02:33 AM, Антонио Антуан wrote: > > > > I have the query: > > | > > q =Session.query(func.array_agg(Order.col)) > > | > > > > The compiled query will be: > > | > > SELECT array_agg(order.col)FROM orders > > | > > > > I want dynamically replace the existing column. After replacing query > > have to be: > > | > > SELECT group_concat(orders.col)FROM orders > > | > > > > I have to use Session and model. I don't have to use SQLAlchemy core. I > > don't have to use subqueries. And, of course, there can be some other > > columns, but I need to replace only one. I tried to replace objects in > > `column_descriptions` property, I tried to use `q.selectable.replace`(or > > something like this, sorry, but I don't remember right names) and I > > didn't get right result. > > > > Can I do what I want? > > > > -- > > 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+...@googlegroups.com <javascript:> > > <mailto:sqlalchemy+unsubscr...@googlegroups.com <javascript:>>. > > To post to this group, send email to sqlal...@googlegroups.com > <javascript:> > > <mailto:sqlal...@googlegroups.com <javascript:>>. > > Visit this group at https://groups.google.com/group/sqlalchemy. > > For more options, visit https://groups.google.com/d/optout. > -- 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 https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.