http://www.perlmonks.org?node_id=836647


in reply to Re^2: DBI - Table names & placeholders
in thread DBI - Table names & placeholders

You could produce and prepare the specific queries as you need them. It would be easy and inefficient to use each statement once. Alternatively you could cache them and reuse them. A hash keyed on the table name to hold the prepared statements or a simple sub to prepare them combined with memoize.