Hi, you mean a label? Just use parentheses:
sql = Query([ (Trademark.name + " " + Model.name).label("combined_name"), Model.id.label("id") ]).filter(Model.trademark_id==Trademark.id) HTH, - Gulli -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.