I should note i have seen sql::abstract and the chapter in advanced perl about template driven code generation but the latter is way beyond my skillset