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 [email protected] <mailto:[email protected]>. To post to this group, send email to [email protected] <mailto:[email protected]>. 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
