FWIW, AFAIK, its temporary, for creating reports, like SQLite::VirtualTable::Pivot shows

Given this table :

 Student Subject    Grade
 ------- -------    -----
 Joe     Reading    A
 Joe     Writing    B
 Joe     Arithmetic C
 Mary    Reading    B-
 Mary    Writing    A+
 Mary    Arithmetic C+

A pivot table created using the columns "Student" and "Subject" and th
+e value "Grade" would yield :

 Student Arithmetic Reading Writing
 ------- ---------- ------- ----------
 Joe     C          A       B
 Mary    C+         B-      A+
[download]

Because I forgot all about VIEWS/PIVOT, I did the transformation manually.