How does someone learn SQL these days and go about getting a job doing it, without having it drilled into them that you must never concatenate strings and stick

How does someone learn SQL these days and go about getting a job doing it, without having it drilled into them that you must never concatenate strings and stick them in a raw query? Isn't anyone who's capable of learning SQL capable of understanding this?