title: DBI: selectall_arrayref and columnnames
body: <p>When I fetch the data this way is it possible then to access the column names and the column types or do I need an explicit <code>prepare</code> to reach this?</p>
  
  <pre><code>use DBI;
  
  my $dbh = DBI-&gt;connect( ... ); 
  my $select = "...";
  my @arguments = ( ... );
  
  my $ref = $dbh-&gt;selectall_arrayref( $select, {}, @arguments, );
  </code></pre>
  
  <p>Update:</p>
  
  <p>With <code>prepare</code> I would do it this way:</p>
  
  <pre><code>my $sth = $dbh-&gt;prepare( $select );
  $sth-&gt;execute( @arguments );
  my $col_names = $sth-&gt;{NAME};
  my $col_types = $sth-&gt;{TYPE};
  my $ref = $sth-&gt;fetchall_arrayref;
  unshift @$ref, $col_names;
  </code></pre>