Thank you for you answer,but I'm sorry,I don't quite follow you. My confusion is that with the "s.query(User).all()",SA issues SQL stmt the same as "user_table.select().execute()",but why the latter stmt can return the row what I expected whereas the former couldn't?
besides,the table in DB change nothing after reflection,just like original one(no PK there) : user_table = Table('user', metadata, Column('id', Integer), Column('name', Unicode) ) -- 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.