kysely icon indicating copy to clipboard operation
kysely copied to clipboard

add mssql's `output` clause support.

Open igalklebanov opened this issue 2 years ago • 0 comments

Hey 👋

Now that mssql dialect is in the core, it's time to pick and choose which clauses and keywords should get support in Kysely's query API.

The OUTPUT clause, is pretty much returning clause, but with deleted and inserted (both are available in update queries so you could return new and old values) "tables" in context.

This one seems like an easy win. Without it, consumers will have to perform another query in inserts to get IDs.

igalklebanov avatar Sep 09 '23 15:09 igalklebanov