XF 2.2 How to run single delete query in template

[FoxSecrets]

How to run a single DELETE query in template something like the select below but not in loop?

<xf:foreach loop="$xf.app.db.fetchAll('SELECT xxxxxxxx FROM xxxxxxxx WHERE id=1')" value="$item">
      //....
  </xf:foreach>

Edit: please delete this thread, i've got a similar from another post.
Template only perform read operations

 

[Jeremy P]

Templates are read-only, you should perform deletions in the controller.