if no records match
   (content)
else
   foreach record
      (content)
   end
end

##</code><code>##

[% RAWPERL %]
   local $Template::Plugin::DBI::ITERATOR =
      'Template::Plugin::DBI::IteratorZ';
[% END %]

...

[% SET query = DBI.query( 'SELECT rows FROM table' ) %]
[% IF query.last %]
   content
[% ELSE %]
   [% FOREACH item = query %]
      content
   [% END %]
[% END %]

...

[%# Still works the old way %]
[% FOREACH item = DBI.query( 'SELECT rows FROM table' ) %]
   content
[% END %]