If you are a Drupal Developer using the Views module, is probable you want the option to rewrite the SQL query executed for this module.
Maybe because you think it's easier this way or maybe because you can't do complex stuff like grouping elements, or an argument taxonomy negation or something similar.
No matter the reason why you need to change the query, now you can do this using the module Views modify query.