Pivetta, at his age and as the most versatile pitcher on the staff, would be a fine addition to a good team. He has done well, at times, at starting, bulk relieving, even closing in the postseason.
Pivetta should be highly valued for a team sincere about rebuilding, but he may not be worth keeping for a bad team more concerned about budgets than paying market prices for good players.
However, it is hard to imagine his trade value would return anything more than a prospect in a salary dump. Unless he's part of a multi-player package, nobody is going to give up a young controllable starting pitcher or MLB-ready position player for Nick.