hmm actually I want to modify for the database rather than for the display.
I.e. I want to assign points to a certain playerID based on its positionID and other characteristics. (e.g. if player is a defender (positionID = 1) and he scores a goal (goal_scored = 1) then he receives a certain amount of points.)
I could do this the other way where I store the API data in a database (see picture), and then I add the extra “points” columns, but, as you correctly explain here, this method is much slower and takes more space I guess in the backend.
So, the ideal would be to manipulate data on the source and then store the API data type, but as I see this is not feasible 
.