[% FOREACH row IN rows %]
[% query = "SELECT * FROM foo WHERE blah = [% row.account_code %] "%]
[% END %]