So the solution is, push the problem to the end users? Or is the "we will transform in the Data Warehouse" meant that another central team builds the transformation for the users which then have the same issue of spaghetti code?