From another perspective, if you need to look up what columns are in a table, you might find the DBI $dbh->table_info method helpful. After gathering a list of available columns, you can build a query with known columns in a known order, or use bind_columns to bind hash values with the column names as keys; the DBI documentation has an example of this in the description for bind_columns.