可以将原始SQL解析为Zend \ Db \ Sql \ Select对象吗？

Question

is there a way to parse a SQL statement string into a Zend\Db\Sql\Select object?

something along the lines of:

$sql = 'SELECT * FROM table WHERE col1 = "x"';
$select = new Select();
$select->parseSql($sql);

I have many uses for this, basically maintaining the use of a Select object when executing a raw SQL statement, for example to pass to Zend\Paginator\Adapter\DbSelect without having to write a custom Zend\Paginator\Adapter\DbSelect Class.

Answer 1

got one answer through a twitter response, specific to the Paginator use case:

$resultSet = iterator_to_array($adapter->query($sql_statement)->execute());
$iteratorAdapter = new ArrayAdapter($resultSet);
$paginator = new Paginator($iteratorAdapter);