Document the SQLite breaking changes caused by EF7 update pipeline

[ajcvickers]

See dotnet/efcore#29916, dotnet/efcore#29512, dotnet/efcore#29811, dotnet/efcore#30081

Workaround:

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    => optionsBuilder.ReplaceService<IUpdateSqlGenerator, SqliteLegacyUpdateSqlGenerator>();

[SeeIfIDont]

According to the committed documentation, this was supposed to be removed and replaced with a per-table mechanism in .NET 8. .NET 8 RC 2 is now out and I can't find any up-to-date documentation and release notes addressing this either way. What happened to this?

[roji]

This indeed happened - see dotnet/efcore#29916. We now have UseSqlReturningClause (for SQLite) and UseSqlOutputClause (for SQL Server). And we definitely need to document these, opened #4538 to track this.