feat: Migrate `scaffold` to `github.com/cloudquery/plugin-sdk/v2`

### Which problem is this feature request solving?

Part of #9846

### Describe the solution you'd like

Upgrade the code.

### Pull request (optional)

- [X] I can submit a pull request