Right now the plugin incorrectly implements multiple interfaces and it needs to only implement the unmanaged plugin.

Very nice! I really like the bulk-insert. In overwrite I think we can do something similar otherwise it will be quite slow / open many goroutines and so on.

I think in overwrite we should use a temptable and then do a merge on the serverside - it's quite common approach in databases that don't have good built-in batch support.

https://blog.jonschneider.com/2016/08/bulk-upsert-into-sql-server.html
https://stackoverflow.com/questions/4889123/any-way-to-sqlbulkcopy-insert-or-update-if-exists

Great job @candiduslynx !

This one is a complex one for sure as it's an "old" db :)

I played with and overall it looks good. I've a few comments but I'd like to wait for some real world usage to see if users hit any snags.

For example:

1. TVP is really cool but also it adds complexity, which means harder to debug bugs. Can we achieve the same thing with temp tables? maybe and maybe it wont be better as temp tables also have their snags as not everything is happy flow in MSSQL world.

So let's put it out there and once we release tmrw we can update the users that requested that.