I am new to Affinity Photo after years as a Lightroom/Photoshop user and getting away from Adobe and managing my photo library was problematic until I found Capture One Express.
Capture One Express is free. They split the software into specific manufacturer versions. I use Nikon. They have versions for Canon, Sony, Fuji etc.
Capture One Express uses the same RAW editor as Capture One 21 and can manage your library as well. It has a few less features than the full version but for my workflow, I do the basic RAW edits in Capture One Express and move to Affinity Photo for more complex edits.