We are trying to name SQL queries in a fairly intuitive way and place them in a lib file, using SQL::Library. We have read Conway's "Perl Best Practices" as a guideline for naming subroutines. The scheme we have come up with is:

SQLCMD_Action_Object

Some examples:

  sel_count_categories,
  sel_count_clicks_agencyPage,
  sel_count_agency_visits
 = "SELECT 'Visits to detailed agency page:' as report_type, * FROM "
    . "(SELECT COUNT(*) as one_month FROM web_requests WHERE file ~* '
+rm=show_agency' AND file ~* 'agency_id=$agency_id' )
[download]

We are interested in any feedback you could give us on our approach or your suggested approach.