Use of RDBO query builder

gistfile1.txt

    my $st = Rose::DB::Object::QueryBuilder::build_select(
        query_is_sql => 1,
        db           => $self->db,
        select       => 'status_code, COUNT(*) AS tally',
        tables       => [ Bikes::M::Inventory->meta->table ],
        columns      => { Bikes::M::Inventory->meta->table => [ qw( variant_id status_code ) ] },
        group_by     => 'status_code',
        query        => [
            variant_id => $self->id,
        ],  
    );