I’ll check this out. The macOS photo library situation is really embarrassing. I actually migrated from Affinity to DxO Photolab (expensive!) a few years ago just for that.

Hope it's to your liking