SCSIFlash-Fast uses CF or M.2 SSD cards
IDE-SATA adapters are very common (and cheap), but this seems like SCSI-SATA which is definitely far less common; I know there is also SAS, but I'm not sure how that compares. There have been IDE-SCSI adapters made in the past too, but they've also become rare and expensive:
https://duxbridge.wordpress.com/2012/01/15/creating-ssd-for-...
as well as the device being firmware upgradable via USB
My first thought upon reading that was "that seems overly complex". Looking at the rest of the features, this seems more like an embedded system doing the translation rather than a simple (hardware IP) adapter.
SAS is basically two channel SATA with independent command queues, and can drive SATA drives, but SATA can't drive SAS.
SATA at 600MB/sec is plenty fast for contemporary mainstream server applications , which you can scale up with RAID 5/6/10 with some error resilience.
For higher throughput (plus more IOPS generally), SAS RAID comes into play. AI and processing servers generally come with NVMe disk stacks, configured with mdraid / RAID 0 generally, because the data is generally ephemeral, so losing the data is highly unlikely. You restart what you do on an other server, most of the time.
There's probably an FPGA or fast DSP which can handle signal/protocol translation with some state handling coprocessor on board, not unlike a (spinning) disk controller.