...
It’s expensive, as it requires a software developer to make a change.
It is slow, and customer does not to wait.
It makes you application complicated, the fishmonger does not want to have to trawl (Sorry for the pun!) through a list of fields about fridges to capture the vital details about there fish.
So at some point you add flexibility to your application and allow a user of your application to add their own fields. In fact you probably allow them to add new fields to multiple different tables within your application.
Life is great everyone is happy! except your Business Intelligence developer. 😖
Traditional Solution
How this is solved historically in Business Intelligence tools.
...