my $statement = "select * from $ref";
to
my $statement = "select * from $ref order by foobar";