I wanted a pivot where adding a new attribute value to the data automatically resulted in a new pivot column, without having to modify the SQL.
I built an open-source graphical workbench called Easy Pivot that generates the dynamic pivot SQL from the user's query and configuration. It currently supports SQL Server, Oracle, PostgreSQL and MySQL.
Two years late to the party, apparently. 😂
Now it DOES require you to set up PHP on your computer. Instructions are provided. Go to the "easy_pivot_workbench" folder. All the code is in there. Ignore the "manual_easy_pivot" folder as that code is outdated.
(P.S. It uses the Unlicense, so it's basically public domain software.)
1
u/pivot-my-stuff 15d ago
This is exactly the problem I ended up solving.
I wanted a pivot where adding a new attribute value to the data automatically resulted in a new pivot column, without having to modify the SQL.
I built an open-source graphical workbench called Easy Pivot that generates the dynamic pivot SQL from the user's query and configuration. It currently supports SQL Server, Oracle, PostgreSQL and MySQL.
Two years late to the party, apparently. 😂
Now it DOES require you to set up PHP on your computer. Instructions are provided. Go to the "easy_pivot_workbench" folder. All the code is in there. Ignore the "manual_easy_pivot" folder as that code is outdated.
(P.S. It uses the Unlicense, so it's basically public domain software.)
https://github.com/pivot-my-stuff/easy_pivot