demo tsql a troff preprocessor for using sqlite in troff

sqlval.troff

.\" cat THISFILE | tsql | tbl | groff -Tpdf > THISFILE.pdf

Store info
.sqldb :memory:

.sqlbeg
create table Fam (
name text,
id integer
primary key
);
insert into Fam (name) values ('Gavin'), ('Chris'), ('Greg');
.sqlend

.TS
allbox;
cc.
name	id
.sqltbl
select * from Fam;
.sqlend
.TE

.nr id 5

\n[id]

\"{{{
.sqlnr id
select id from Fam where name = 'Chris';
.sqlend

\n[id]

.sqlds name
select name from Fam where id = 2;
.sqlend

\*[name]
\"}}}