Be aware that because of the preg_match( '/^\s*(insert|delete|update|replace)\s/i', $query ) check inside this function, you may be surprised to not receive the expected $wpdb->rows_affected (and will miss the $wpdb->insert_id too) if you have anything except whitespace characters before the UPDATE/INSERT/etc. statement, e.g.:
preg_match( '/^\s*(insert|delete|update|replace)\s/i', $query )
$wpdb->rows_affected
$wpdb->insert_id
