Comment by GrayShade

I disagree. The amount of optimization that a query planner does is vastly more than a web application developer would care for.

We have people who can't be bothered to close database transactions (see that Uber report). I wouldn't trust then to choose the optimal join strategy in a complex query.