my $sql =<<'EOFSQL'; SELECT LOWER(field_one) AS field_one, field_two, UPPER(field_three) AS field_three FROM sample_table (NOLOCK) WHERE field_one = ? EOFSQL