is it possible to force the order of primary keys?
for example in this setup...
class AcmeDnsServer2Domain(Base):
__tablename__ = "acme_dns_server_2_domain"
acme_dns_server_id = sa.Column(
sa.Integer, sa.ForeignKey("acme_dns_server.id"), primary_key=True
)
domain_id = sa.Column(
sa.Integer, sa.ForeignKey("domain.id"), primary_key=True
)
I want to influence the creation of the primary key to be ["acme_dns_server_id", "domain_id"]
In several projects I've worked on, the order has been important. (it can affect query planning and caching)
I thought I had seen something in the docs several years ago, but I just spend a few fruitless minutes trying to find it.