Actually it does, I worked it out. This returns the file name.
$sql_author_image = "SELECT meta_value FROM wp_usermeta WHERE user_id = $user_id AND meta_key = 'author_image' ";
$author_image = $wpdb->get_var($sql_author_image);
Then all you have to do is create an add_shortcode
function.