I feel that many coders have a very basic understanding of SQL, don't really want to get better at it, and don't really care.

If they can get away with a query that takes 2s to return a single row, they will be quite content and will not be bothered to look at the query plan.

It's a shame, because everything could be a little better with hardly any effort.