Select Code to Download

sub recursive_subquery{
    my($schema,$join_column,$key,$values)  = @_;
...
    }
    return $sub_query;
}

$c->stash->{rows} = $c->model('DB::Post')->search({
    'posts.post_id' => {
...
        ])->get_column('post_id')->as_query 
    },
});