How to rewrite View SQL query to bypass MySQL query cache (SELECT SQL_NO_CACHE)
I don't want to say that this is impossible, but it's very close to be true.

The problem is that Views uses the Drupal SQL builder, so when making a select query, it utilizes the SelectQuery which again uses PDO from PHP. PDO can be used in two ways, either you feed it a query, or you can use it to build a query by instantiating the class and dosing stuff like

$query = ...;
$query-&gt;addField(...);
$query-&gt;addCondition(...);
$result = $query-&gt;execute();


The challenge is that you need to tell PDO that you don't want to make a regular SELECT query but instead an SELECT SQL_NO_CACHE query. I don't know if that is possible of how you would do it if it were. Even if it is possible, you still need to figure out how to do it through all the abstractions of classes created by PDO and Drupal and Views.

Drupal has a hook you can use to alter queries in general which probably will be the easiest route if you can figure out the above: hook_query_alter, alternatively you can subclass views_plugin_query_default defined in Views, where you can add alter how the query is created to add SQL_NO_CACHE. Again PDO and abstractions is the challenge.

If you are using Drupal 6 this should be more simple and you can probably use something like hook_db_rewrite_sql.