code: public function runSql($query, $queryParams = array())
      {
          /** @var Magento_Db_Adapter_Pdo_Mysql $connection */
          $connection = Mage::getSingleton('core/resource')->getConnection('core_write');
          /** @var Varien_Db_Statement_Pdo_Mysql $statement */
          $statement = $connection->query($query, $queryParams);
  
          return $statement->fetchAll(PDO::FETCH_ASSOC);
      }
docs: Returns results as assoc array for specified SQL query
  
  @param string $query
  @param array  $queryParams
  @return array
  @throws Zend_Db_Statement_Exception