This may be obvious and unhelpful, but for my need I just use `.mode list` And create my own HTML markup with: `UPDATE myTable set ln = '<a href="' || ln || '">' || ln || '</a><br />' WHERE ln like 'http%';` (Where "ln" is a text field with an entire line of output.)