If I have a simple join-based inheritance relationship in SQLAlchemy that I've replicated between schemas using "SET search_path", how can I access them simultaneously in order to do a copy between them?
I've looked at things like the entity name recipe and it's not quite clear how to do it in the case of an inheritance. I've also looked at select_from but it's not clear how the subclasses would load if with_polymorphic is spec'd on the parent class.
Ideally, what I would like to do is iterate over a version of my class tied to the public schema and generate copies of it as instances of the same class tied to the particular schema in question.
