perl-sql-abstract-classic 1.91 Generate SQL from Perl data structures
This module is nearly identical to
SQL::Abstract 1.81, and exists to preserve the ability of users to opt into the new way of doing things in later versions according to their own schedules.
It is an abstract SQL generation module based on the concepts used by
DBIx::Abstract, with several important differences, especially when it comes to
WHERE clauses. These concepts were modified to make the SQL easier to generate from Perl data structures.
The underlying idea is for this module to do what you mean, based on the data structures you provide it. You shouldn't have to modify your code every time your data changes, as this module figures it out.