How to Override Drupal Views Query?

Question

How can I replace a Views 3 query with a custom SQL query in code?

Answer 1

From what I understand, you can use hook_views_query_alter to modify the query. I would assume you could also use it to replace the query. Here are a couple hook_views_query_alter examples, to get you started:

• Using Hook Views Query Alter
• Alter a View query to add a WHERE clause with OR group operator.