As the name says, it is an extended version of PDO. Good thing is it is
PHP 5.3 compatible.

If you have worked with PDO you know the good and bad.
One of the difficulty is, it cannot use an array for an in clause.

1234567891011

<?php// the array to be quoted$array=array('foo','bar','baz');// the statement to prepare$stm='SELECT * FROM test WHERE foo IN (:foo) AND bar = :bar'// the native PDO way does not work (PHP Notice: Array to string conversion)$pdo=newPdo(...);$sth=$pdo->prepare($stm);$sth->bindValue('foo',$array);

ExtendedPDO helps you to do it.

123456789

<?php$pdo=newExtendedPdo(...);$stm='SELECT * FROM test WHERE foo IN (:foo)';$pdo->bindValues(array('foo'=>array('foo','bar','baz'),'bar'=>'qux',));$sth=$pdo->prepare($stm);echo$sth->queryString;

Try out an example, and see in action.

Your composer.json will look as

123456

{"minimum-stability":"dev","require":{"aura/sql":"dev-develop-2"}}

Run the below Sql query in your favourite tools like phpmyadmin or adminer.