add `OUTPUT` clause support.

[igalklebanov]

Hey 👋

output clause is supported in dialects such as MS SQL Server (MSSQL).

It works just like returning, but:

• forces columns to be prefixed with inserted for new values, deleted for old values, and table names/aliases that are not the main table. Since we don't support mssql's way of adding more tables to context in all the queries output is supported in, I left it out for a future PR.
• for merge queries, $action that returns delete, insert or update. if #700 gets merged, need to add this - will be quite easy.
• can be used to insert into a variable or another table with the into sub-clause. left it out for a future PR.

[vercel[bot]]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name	Status	Preview	Comments	Updated (UTC)
kysely	✅ Ready (Inspect)	Visit Preview	💬 Add feedback	Mar 23, 2024 5:19pm

[khangal]

👏👏👏👏👏👏

[tmrclark]

When will this be getting released?

[magnusrodseth]

@igalklebanov @koskimas Is this on its way to be published? I cannot find docs on how to use it.