If you are buying a standalone SSHD with built-in SSD caching then no, as it is part of the drive and nothing to do with the SATA controller.
If you are buying a standard HDD to use with your existing SSD to create a SSHD yourself, then yes, that functionality requires RAID mode.