This article is everything that's wrong with SQL.
How about just providing us access to the query plan and allowing users to directly modify it? It's like needing assembly language to optimize a really tight section of code but having that access blocked off.
Why do we have to rely on leakage to a higher level interface in order to manipulate the lower level details? Just give us manual access when we need it.