In your connect method, there really isn't a need for the find variable at all. You can use an anonymous hash instead.

sub connect{
    my $class = $_[0];
    
    if (-e "$_[1]"){ 
    
        my $object = {
            connect => $_[1],
            prepare => '',
            select => '',
            where => {},      #anonymous hash reference
            column => '',
            records => '',
        };
                   
        bless $object, $class;
        return $object; 
    }
    else{
        die "file: $_[1] doesn't reside at path\n";
    }            
}
[download]

Also, you don't have to put it into a local variable in order to assign something to it:

$self->{where}->{name}='test';
[download]

Ditto the stuff about exporter. You may have picked it up if you started a package using h2xs -XA foo. But in my experience the exporter isn't needed for objects. (And when it is the use base Exporter; eliminates a bunch of lines.)