> studies at Microsoft and elsewhere showing it’s closer to 14 percent

This is a depressing stat. The real productivity gains come from leaving soul sucking big tech companies where nothing gets done with any sort of urgency.

In my open source work I believe this is the same. I don't have numbers, but I'm sure the vast majority of my time isn't spent writing code. Of course, it depends on how you define "writing code".

It is not urgency. Large production systems mean you are doing mostly unsexy operational planning. If I had a dollar each time I hear the word "data migration" I reckon I could do well.