How to alter view query I am just looking for altering select query, created by any view just before its execute. For e.g. I want to add some manual filter which I can't add from Views' UI.
You are likely looking to use hook_view_query_alter, additionally you might want to look into some related questions on Drupal answers How do I use hook_views_query_alter()?.