Yea that's what I'm using on my build just now, 6 x PCIe risers and plug the sata from the PSU directly in... When I'm looking just now though i see most off them now have sata to 6 pin though.
Maybe what you mean is ATA/Molex, I also never seen riser with SATA power. The old Riser using "SATA to MOLEX " power, and we can power it directly from PSU using Molex.