OnConflict / Merge (upsert) in MSSQL

[code-cream]

Environment

Knex version: 2.4.2
Database + version: MSSQL
OS: Windows

Feature discussion / request

1. Explain what is your use case

I'm struggling to find examples of how I can implement upsert functionality for MSSQL using Knex. Any advice for those trying to implement a pattern similar to onConflict().Merge() , but for MSSQL? Are there any plans to include onConflict or merge support for MSSQL eventually?

I dug into the implementation thread for pg/mysql and it seems like it was close but some tests were not passing. I'd be happy to attempt to contribute, especially if i'm not missing some larger reason why it isnt supported.

@smorey2 thank you so much for the assistance

2. Explain what kind of feature would support this

Ideally onConflict and merge would be available for MSSQL so that they can be used in a db agnostic way.

3. Give some API proposal, how the feature should work

The same way it does for postgres and mysql would be amazing