You cannot connect a SAS HDD to a SATA port with any sort of cable. You need to install a SAS controller card into your computer, and consumer PCs and Macs don't normally have those.
The reason you see so many SAS refurbished drives for so cheap is that people like you mistakenly buy them and discover they can't make them work on their computers, so they return them or try to fob them off on eBay and the like.
Funny enough I bought a SATA drive from an e-tailer new as a spare and when I went to open it up months later realized that they had mistakenly shipped me a SAS drive of the same capacity (18TB). So it’s well beyond the return / exchange period despite the shipping error. I have equipment to run it but it kind of threw a fork in my plans because I was going to get rid of said equipment. All for that $300 spare drive.
This is an SAS drive. It requires an SAS controller. This cannot be solved with software.
If you really want to use SAS drives, it can be done with a Host Bus Adapter PCIe card. You will need to be careful about researching whether the HBA you want to buy is compatible with the motherboard you want to use, and that drivers for that HBA exist for the OS that you want to use.
This may not be cheaper than just buying SATA drives. This is server hardware intended for use with server motherboards, there's no guarantee that it will work properly with a consumer-grade system.