SOQL is like ssql, but worse! No joins, no unique, no returning more than 2000 results at a time. Visual force is like java server pages, but worse because it

SOQL is like ssql, but worse! No joins, no unique, no returning more than 2000 results at a time. Visual force is like java server pages, but worse because it injects all sort of stuff into the rendered page like these wierd ids, stop you from using a lot of basic html between the visual force tags. And finally, they have been pushing so hard for their redesigned UI , lightning. Problem is that it is much much slower than the old pages by a lot.