I am not sure if this helps or not, but the Primary key in SqlAlchemy doesn't need to be the same as the Primary key in the database. You may be able to work around the constraints of your system by divorcing the two concepts from one another (I have, but not in an example I can easily adapt to your case).
-- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/dd13e901-bf9b-49c6-b8e5-df2666d9b40f%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
