SQL No Cache Support for Varien DB select

sql-no-cache.diff

diff --git a/lib/Varien/Db/Select.php b/lib/Varien/Db/Select.php
index 4af0818..e7c01c5 100755
--- a/lib/Varien/Db/Select.php
+++ b/lib/Varien/Db/Select.php
@@ -59,6 +59,12 @@ class Varien_Db_Select extends Zend_Db_Select
     const SQL_STRAIGHT_JOIN = 'STRAIGHT_JOIN';
 
     /**
+     * define callback for rendering sql no cache support***
+     */
+    const SQL_NO_CACHE = 'sqlNoCache';
+
+
+    /**
      * Class constructor
      * Add straight join support
      *
@@ -70,6 +76,11 @@ class Varien_Db_Select extends Zend_Db_Select
             self::$_partsInit = array(self::STRAIGHT_JOIN => false) + self::$_partsInit;
         }
 
+        //extend parts within SQL_NO_CACHE support
+        if (false === isset(self::$_partsInit[self::SQL_NO_CACHE])) {
+            self::$_partsInit = array(self::SQL_NO_CACHE => false) + self::$_partsInit;
+        }
+
         parent::__construct($adapter);
     }
 
@@ -471,4 +482,29 @@ class Varien_Db_Select extends Zend_Db_Select
         $this->where($exists);
         return $this;
     }
+
+    /**
+     * add SQL_NO_CACHE to bypass querycache usage
+     *
+     * @param bool $flag
+     * @return Varien_Db_Select
+     */
+    public function sqlNoCache($flag = true)
+    {
+        $this->_parts[self::SQL_NO_CACHE] = (bool)$flag;
+        return $this;
+    }
+    /**
+     * render SQL_NO_CACHE to bypass querycache usage
+     *
+     * @param string $sql SQL query
+     * @return string
+     */
+    protected function _renderSqlNoCache($sql)
+    {
+        if ($this->_parts[self::SQL_NO_CACHE]) {
+            $sql .= ' SQL_NO_CACHE';
+        }
+        return $sql;
+    }
 }

Example

/** @var Varien_Db_Select $select */
$collection->getSelect()->sqlNoCache(true);

SELECT SQL_NO_CACHE * FROM catalog_product_flat_1 AS e