I think it would depend on your BIOS' capabilities as well as its configuration.
In my experience with more recent motherboards their BIOS maps SATA drives
just like PATA drives, so even legacy OSs like DOS, Win95, etc. will be able to
'see' and run off of SATA drives attached to motherboard controllers.
It is a similar case with add-on controllers with BIOS extensions onboard.
If you ensure that the motherboard BIOS and SATA controller / RAID
controller BIOS is updated as fully as possible (and is enabled), you
may find that you have no major problem.
The configuration matters in that if you configure the SATA drives' modes as
individual disks or JBOD then operating systems and programs should be able
to see the individual drives and their partitions without problem.
If you however configure the drives as a RAID group it may not be fully usable
without software RAID drivers loaded into the operating system unless your
hardware is doing totally 'transparent' hardware assisted RAID that needs no
operating system drivers.
Once you load any necessary drivers for your SATA controllers and/or RAID
controllers, though, any software running under your operating system should
be able to detect/image/backup your logical partitions without problem in the
case of a software-assisted RAID and it should be able to analyze/image the
physical drives and partitions in the case of non-RAID SATA disks.
If you use "standalone" software that doesn't run under an OS for drive data
imaging then you may have a problem seeing drives attached to RAID or
SATA controllers that software doesn't have built in drivers for in the case
where the system BIOS doesn't manage the controllers' drives fully.
In such a case I'd try to get an updated 'driver' or library or whatever
for the backup product in question that allows it to access those kinds of
SATA/RAID controllers.
However in the best non-software-RAID case no special software will be needed
due to BIOS support of the controllers.
If you want best-compatibility for RAID SATA configurations, use a RAID mode
or RAID controller that is totally hardware/BIOS operated and which is 100%
transparent to any program / operating system. This might well be the case
with simple RAID-0 or RAID-1 modes, but is less likely to be the case for
more advanced RAID-5 and other modes.
In any case you should be able to backup logical partitions and logical volumes
from within an OS with the appropriate controller / RAID drivers loaded.
If you can get access to the individual drives from a low level backip utility you
should be able to clone the drives too, though in the case of a RAID that's
usually not terribly useful since it'll not be always possible to use any
"backup" of an individual RAID disk's contents absent the contents of
the other drives that are part of a striped or RAID-5 set. Mirrored drives
are more usable independently, of course.
Often there's some capability to use a BIOS or software tool that comes with
your SATA/RAID controller to "clone" or regenerate a newly
installed RAID drive's proper contents based on intact units already in the
RAID to replace data on a failed drive which had been in a RAID-5 or mirrored
set.
I guess in the worst cases naive single drive imaging programs become
less useful than RAID management and logical volume oriented backup utilities.
You should learn to boot into an OS in some kind of administrative or
safe-mode that's got any needed SATA/RAID drivers in place and backup
software but under which there aren't going to be many/any programs actively
using the data on the SATA/RAID system so you can do backups and such
more safely without the data being backed up being under frequent use.