Static-column pivot table Dynamic-column pivot table This how-to explores how to build pivot tables in SQLite, which doesn't have a special constructs like PIVOT or CROSSTAB in its SQL dialect.

Dynamic-column pivot table SQLite in sqliteviz is built with pivot_vtab extension. The same result set can be produced with this, arguably simpler and more maintainable, query.