From DBI.pm:

       "FetchHashKeyName" (string, inherited)
           This attribute is used to specify which attribute name
           the fetchrow_hashref() method should use to get the
           field names for the hash keys. For historical reasons
           it defaults to '"NAME"' but it is recommended to set
           it to '"NAME_lc"' or '"NAME_uc"' according to your
           ...

So something like this is probably what you want:

    $dbh->{FetchHashKeyName} = 'NAME_lc';
[download]

Also, if you implemented LIMIT in code, you could try rownum, eg:

    select *
    from   foo
    where  rownum < 6;
[download]