Can you write a part of code making this manual paging. I'm looking to this sample to do my realization:

$C->{stuff} = $schema->storage->dbh_do(
sub {
my ($storage, $dbh, @cols) = @_;
my $cols = join(q{, }, @cols);
$dbh->selectrow_array("SELECT $cols FROM foo");
},
@column_list
);
[download]

But how to use it in TT? Is it return the same result as traditional $schema->search();