Thanks for sharing useful Info Thomas.
I had a case recently in my org where data is moved to SQL Server already but coming towards the derived column part, one challenge I saw in my company recently was: Calculate the difference in price per square foot relative to the two immediate neighbors.
This one is like  you need to know the data from previous or next rows to make this calculation. Is there any easy way to achieve this?