Summary: Function returns the value of the specified option $setting.
Detail: This is a surprisingly complex function that returns the value of the specified options $setting. It first checks for the existence of a wp-cache value, and if none exists, queries the database.
The rest of the function complexity is simply to make sure that a properly-validated URL is returned if the requested option is the site URL.