I can see parallels to the world of office productivity software. When we moved from desktop based (legacy MS office) to cloud based (Google Docs/sheets), some of the shifts you call out happened i.e. 1/ simultaneous collaboration between multiple participants 2/ single source of truth 3/ processing moved to cloud, but the unit of work still... See more

Excel may be the most influential software ever built. It is a canonical example of Steve Job’s bicycle of the mind, endowing its users with computational superpowers normally reserved for professional software engineers. Armed with those superpowers, users can create fully functional software programs in the form of a humble spreadsheet to solve... See more

Unfortunately, Excel lets you do all kinds of complicated transformations of data, and yet lacks any sort of history of the sequence of those computations. The ability to copy and paste data into a tab that serves as a database means that any steps leading up to the pasted data are lost.