I say that in any case where SQL is being used, knowing the queries and being able to optimize them by hand is crucial to the core performance of the application. It should absolutely be required knowledge. There are some guys in my company using java that work at a higher SQL abstraction level and their apps are slower than molasses. A little hand sql tuning and it turned to tip top shape.