in reply to 'automating' SQL queries, use Class::DBI?

Yes
perldoc Class::DBI

...
INTRODUCTION
    Class::DBI provides a convenient abstraction layer to a database.

    It not only provides a simple database to object mapping layer, but can
    be used to implement several higher order database functions (triggers,
    referential integrity, cascading delete etc.), at the application level,
    rather than at the database.
  • Comment on Re: 'automating' SQL queries, use Class::DBI?