cannot write file because it would overwrite input file

There's countless issues about this error and I thought it would be useful to write a clear explanation of what's going on and a summary of the possible solutions.