Any good new motherboard will have between 2 and 6 SATA connectors built in, meaning that the motherboard natively supports them without drivers.
Just to be clear, most modern motherboard can have the SATA ports in two different modes (selectable in the BIOS):
Legacy/IDE Mode: In this mode, no drivers are required. Windows treats the SATA drives just like IDE drives. However, in this mode, some native SATA functionality (specifically, NCQ and Hot Swap) is lost.
SATA Native/AHCI Mode: This is the native SATA mode. In this mode, NCQ and Hot Swap are enabled for all SATA devices. However, this mode requires a manufacturer driver. If you're installing Windows onto a drive attached to the motherboard while in this mode, your have to use F6 and a floppy to install drivers during Windows installation.
Some motherboards have a 3rd mode for the SATA controller:
RAID Mode: In this mode, the SATA controller displays a message of it's own during the power-on self test (POST). You can activate the RAID BIOS during POST and define a RAID array with multiple SATA drives. This mode also requires a driver to be installed, sometimes a different driver than the one for SATA Native/AHCI mode.
This switchability only applies to the SATA ports that are native to the motherboard chipset. If the motherboard has an additional SATA controller (Silicon Image, Promise, Highpoint, etc.), that controller always requires a driver. Usually you don't need to install that driver with F6/floppy during Windows installation, because the startup drive is not attached to that controller. You can install drivers for the extra SATA controller after Windows is installed and running.