Can raw SQL be parsed into a Zend\Db\Sql\Select object?

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.

Ahmad Nassri · Accepted Answer · 2014-03-26 03:39:16Z

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);

answered Mar 26, 2014 at 3:39

Ahmad Nassri

1,3681 gold badge12 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ahmad Asjad Over a year ago

no benefit if you are searching from huge data. On every page it'll send all data, although you'll only see some of data on the page. On every page, you'll execute something like "select * from table_name"

Ahmad Asjad Over a year ago

it'll not add limit to your query, whereas when using DbSelect Adapter, Paginator will automatically add limit to your query

Collectives™ on Stack Overflow

Can raw SQL be parsed into a Zend\Db\Sql\Select object?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related