$api_name[0] = 'get_country()';
$var_name[0] = 'Country';

##</code><code>##

for my $row ( @{ $res->rows } ) {
$Country = $row->get_country();
$sql = "insert into table set country = '$Country'... etc

##</code><code>##

$[$var_name[0]] = $row->$[$api_name[0]];