How to run raw SQL Query with Zend Framework 2

mysql, zend-framework2

Solution

use Zend\Db\Sql\Sql;
use Zend\Db\Adapter\Adapter;

$dbAdapterConfig = array(
    'driver'   => 'Mysqli',
    'database' => 'dbname',
    'username' => 'dbusername',
    'password' => 'dbuserpassword'
);
$dbAdapter = new Adapter($dbAdapterConfig);

$sql = new Sql($dbAdapter);
$select = $sql->select();
$select->from('testTable');
$select->where(array('myColumn' => 5));

$statement = $sql->prepareStatementForSqlObject($select);
$result = $statement->execute();

S. docu: Zend\Db → Zend\Db\Sql

Problem

Is there a way to execute a SQL String as a query in Zend Framework 2? I have a string like that: ``` $sql = "SELECT * FROM testTable WHERE myColumn = 5" ``` now I want to execute this string directly.

Original source