You will only be able to use a SATA SSD if you have a very old MBP that came with a HDD. And even then, some of them use a connector with a proprietary temperature sensor. You'll need to transfer the sensor and connector to the SSD, otherwise the fan will run a full (noisy) speed.
https://everymac.com/systems/apple/macbook_pro/index-macbookpro.html
The MBPs which ship with SSDs use proprietary SSDs. The only compatible replacement SSDs are made by OWC.
https://eshop.macsales.com/shop/ssd/owc
Assuming these conditions are met, the drive will work just fine. OS X formats drives as HFS+ (as opposed to NTFS for Windows, ext2/3/4 for Linux). Though I believe they've got a newer file format for SSDs. The installer or Disk Utility will handle this for you. Lack of TRIM was a problem on earlier OS X releases (Apple was slow to recognize the usefulness of SSDs), but you should be OK with High Sierra.