CREATE VIRTUAL TABLE contacts USING fts5(name, department);
INSERT INTO contacts (name,department) VALUES ('John Doe','Perl');
INSERT INTO contacts (name,department) VALUES ('Larry Wall','Perl');
INSERT INTO contacts (name,department) VALUES ('Gloria Wall','Perl');

##</code><code>##

$c->sqlite->db->query(
  q{ SELECT rowid,name,department FROM contacts WHERE name MATCH ? },
  $c->stash('query') )->arrays );