Imagine this situation: you know DBI and you like it, because you can make use of your SQL knowledge. But you are not happy having the SQL code into the Perl code. You can use other CPAN modules, which let us to abstract SQL code. But we want to write SQL code, we feel confortable with it.
The SQL::Template module manages this ideas:
- decoupling SQL sentences from Perl code, writting sentences in a XML file, that you can use in different parts of your code.
- Dynamic test of expressions.
- Reuse of SQL fragments.
- Simple API (very close to DBI).
I invite you to see and use this module (it's production ready). Comments are welcome.