Conclusions
  
  - SQLite::VirtualTable::Pivot is faster for queries with many constraints
    and small result sets.
  - Transparent manipulation of pivot tables simplifies the application.
  - Further algorithm development may improve performance, perhaps using
    an aggregate view for certain queries.