I’m not 100% sure but this might also depend which OS you are running on your pi. Did change from SD card to SSD few years back for my home assistant setup (now running with a mini pc) at the time I went for a geekpi adapter (can’t recall exact model).

Try a quick ducduck search “sata adapter #yourOS#” and see if a list come up. Here is one for HA (but surely more models are compatible than the ones listed here) community.home-assistant.io/t/…/212763