my $sql = "select id, account_number, CONVERT(VARCHAR(10),date,101) as date
                from my_table where id <> ''
                order by date desc";

##</code><code>##

my @columns = qw( id account_number date );
my $results = $self->_all_data($sql, \@columns);
##</code><code>##

my $results = $self->_all_data($sql);