Sure, everyone has a specialty, but writing frontend and knowing not one line of SQL or how to structure a database or working in the backend but not knowing a bit of HTML or CSS or how to configure a web server, these examples just seem like bad programmers?
You don't need to know everything, but surely you should know enough the have an idea of the system as a whole? How can you avoid doing shoddy work otherwise?