In my experience, structuring a query to execute efficiency requires some basic software-engineering thinking about what's going on, while convincing a query planner to do the right thing requires deep expertise in the query planner.
The advantage is that that can be somebody else's job though, and ideally (eventually) an AI's job.