Fields stemming from relationships are suffixed with _ for no apparent reason

[gfrn]

I'm having an annoying issue with declared relationships on sqlacodegen 3.0.0rc5

Some relationships have normal names, and others have relationship names with an underscore appended to the end (which doesn't bother me):

XFEFluorescenceSpectrum: Mapped[List["XFEFluorescenceSpectrum"]] = relationship(
        "XFEFluorescenceSpectrum", back_populates="BLSubSample_"
    )

But others have underscores appended to the end of them:

BLSampleImage_: Mapped["BLSampleImage"] = relationship(
        "BLSampleImage", back_populates="BLSubSample"
    )

Does anyone know more about what logic sqlacodegen uses to determine what these fields are going to be named? I'd like to make it so these underscores are eliminated. This table in particular doesn't have any other fields named BLSampleImage, so this is not a name conflict

[agronholm]

Could you try with the latest master version to be sure? And attach the entire generated models script if possible, or at least a minimal working example.

[gfrn]

Sorry, that's the full generated model: https://github.com/DiamondLightSource/ispyb-api/blob/orm-update/src/ispyb/sqlalchemy/_auto_db_schema.py

It was generated with sqlacodegen mysql+mysqlconnector://[creds]@127.0.0.1/ispyb_build --options nojoined --outfile _auto_db_schema.py.in

Still happens with master