I have though a lot about the advantage and disadvantages of visual based programming (e.g. Easy Data Transform) vs text based programming (e.g. Python). I wrote a summary of my thoughts here:
I would be interested to hear if you think I missed anything.