The SQL COALESCE function is a conditional expression that returns the first non-null value from a list of arguments. It can take any number of arguments, as long as they are compatible data types.