This is my relevant code:

my $key_field = "ACCOUNT_ID";

my $stmt = "SELECT ea_id AS $key_field, " .
" ea_account_name AS ACCOUNT_NAME, " .
" ea_password AS PASSWORD, " .
" ea_inbox_server AS INBOX_SERVER, " .
" ea_email_address AS EMAIL_ADDRESS, " .
" ea_accept_requests AS ACCEPT_REQUESTS " .
"FROM email_account " .
" where ea_accept_requests = 'Y'";

$email_accounts = $dbh->selectall_hashref( $stmt, $key_field );