Review on 💻 ELUTENG USB 3.0 SATA Adapter - 2.5 Inch SATA to USB 3.0 Cable - 22 Pin 7+15 HDD/SSD Cord - UASP Support - SATA III Compatible for 2.5 SATA Hard Drive (USB C to SATA) by Andrew Burnside

I have this for use with a Raspberry Pi 4 and am using it with a SATA SSD as the main drive. I'd say avoid if you can easily get others, but still worth it if you can put in a few minutes. This adapter works out of the box with USB 2.0 and loads an operating system instead of an SD card. The goal is to use it on USB 3.0, we have to apply some quirks to make it work in USB erase mode instead of UAS mode, which is still better. The chip in this adapter is an ASM105x/ASM115x to SATA bridge which is good for USB boot option. Run lsusb to check the details. Copy the Device ID xxxx:xxxx from the previous step. Add "usb-storage.quirks=xxxx:xxxx:u" to cmdline.txt. Reboot and see if the Pi boots from USB 3.