#27372 changes the SQL Server provider to use OUTPUT without INTO in the update pipeline - this is more efficient, but incompatible with triggers. It also adds a per-table opt-in to allow users to switch to the slower OUTPUT with INTO syntax. This issue tracks adding a custom convention which allows doing that globally.
Depends on:
Split out from #27372