George Sakkis wrote: > > Is there a (public) API for getting the column names of a given Query > instance and other similar introspection needs ? I didn't find > anything related in the docs but after digging in the code I came up > with > col_names = [e._result_label for e in q._entities] > but I'm not sure how stable and robust this is. > > George
Query instances have a 'statement' property that returns the underlying SELECT object. You can then inspect it's 'columns' attribute: columns = list(query.statement.columns) for column in columns: print column.name Would that do what you want? Simon --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---