Ok got around to a very quick test
Summary is seems to work fine. Connected up to an old lsi2208 card with 4 different SSD makes - intel / seagate / hp SAS and a toshiba sata. All were visible in Windows 10 and I did a quick test write to one of them which obviously worked. Only connected to one controller. Didn't have the time to do more and to be honest I bought this on the off chance I might need something later rather than needing it now so probably sits somewhere looking pretty for a while - maybe forever!