Using the where class to dynamically build your query

controller.php

<?php

//...

$cars = $database
    ->createConnection()
    ->getMapFor('YourDb\Garage\Car')
    ->getSportAndColors(array('blue', 'red', 'yellow'))
    ;

using_where.php

<?php

namespace MyDatabase\Garage;

use MyDatabasey\Garage\Base\CarMap as BaseCarMap;
use Pomm\Exception\Exception;
use Pomm\Query\Where;

class CarMap extends BaseCarMap
{
    protected function getWhereForColors(Array $colors)
    {
        $where = new Where();
        foreach($colors as $color)
        {
            $where->orWhere('color = ?', array($color));
        }

        return $where;
    }

    public function getSportAndColors($colors)
    {
        $where = Where::create('type = ?', array('sport'))
            ->andWhere($this->getWhereForColors($colors));
     
        return $this->findWhere($where);
    }
}

using_where2.php

<?php

namespace MyDatabase\Garage;

use MyDatabase\Garage\Base\CarMap as BaseCarMap;
use Pomm\Exception\Exception;
use Pomm\Query\Where;

class CarMap extends BaseCarMap
{
    public function getSportAndColors(Array $colors)
    {
        return $this->findWhere(Where::createWhereIn('color', $colors)->andWhere('type = ?', 'sport'));
    }
}

Problem with my vim Gist plugin. The createWhereIn example is back, thx a lot @pilot