for (keys %{$self->{SQL}}) {
    my $closure = $_;
    $self->{$_} = $self->{DBO}->prepare($self->{SQL}->{$_});
    $self->{"f$_"} = sub {
                            my $self = shift;
                            my @res;
                            $self->{ $closure }->execute(@_);
                            while (my $dbrow = $self->{ $closure }->fetchrow_hashref()) {
                                push @res, \$dbrow;
                                }   
                            return \@res;
                            };  
}