It depends on what templating system you are using. If it allows you to put more logic up to querying database and that's how you display your output, then you might stay with the template. If you don't let the templates hold some control, then you do it in your code.

Nevertheless, additional modules could help you greatly as this kind of thing is so common that CPAN is so rich with solutions.