my $column_names = join( ",", map {
    ( "${_}_open", "${_}_openhour", "${_}_closehour" );
} map {
    lc( $_ );
} @day_text;

my $sql = qq(SELECT $column_names ...);