Handling unpivoted data * Unpivoted table is convenient for inserts. * Pivoted table is convenient for queries. * Can we have both at the same time? * Three techniques : * self join view * aggregate query view * SQLite virtual table using SQLite::VirtualTable::Pivot * Let's compare these techniques.