I completely agree with you. Is SQL perfect? No. Have I accepted and embraced it? Yes, because it'll get the job done.
I also happen to really dislike how the author hasn't capitalized the syntax like SELECT FROM WHERE or CREATE TABLE which, to me, poorly affects the legibility and therefore makes me less interested in reading the argument overall.