#! /usr/bin/env lnav -f

;CREATE TABLE foobar (
    mykey integer primary key,
    name text
);

;INSERT INTO foobar VALUES (1, 'Jules');

;INSERT INTO environ
   SELECT "msg", "Hello: " || group_concat(name, ", ") FROM foobar;

:pipe-line-to
  echo $msg