https://matomo.org/faq/how-to-install/faq_55/
How do I use another database like PostgreSQL, SQLite, Oracle? Will you support NoSQL databases...
postgresql sqlite oracleuse
https://sqlmaestro.com/
Database tools for MySQL, SQL Server, PostgreSQL, SQLite, Oracle, DB2, Firebird by SQL Maestro Group
SQL Maestro Group vendors powerful database management and web development tools for MySQL, Oracle, SQL Server, DB2, SQL Anywhere, PostgreSQL, SQLite, Firebird...
sql server postgresqldatabase
https://modern-sql.com/use-case/pivot
SQL Pivot in all databases: MySQL, MariaDB, SQLite, PostgreSQL, Oracle, …
Pivot SQL tables with CASE or FILTER. Turn rows into columns for the entity-attribute-value model (EAV).
mysql mariadbpivotdatabases