ExecuteUpdate generates invalid SQL for SQLite with TPT

[roji]

This manifests after unblocking ExecuteUpdate TPT support (as long as the updates touch only a single table in the hierarchy).

Example test is TPTInheritanceBulkUpdatesSqliteTest.Update_base_property_on_derived_type:

public virtual Task Update_base_property_on_derived_type(bool async)
    => AssertUpdate(
        async,
        ss => ss.Set<Kiwi>(),
        e => e,
        s => s.SetProperty(e => e.Name, "SomeOtherKiwi"),
        rowsAffectedCount: 1);

SQL:

UPDATE "Animals" AS "a"
SET "Name" = 'SomeOtherKiwi'
FROM "Birds" AS "b"
INNER JOIN "Kiwi" AS "k" ON "a"."Id" = "k"."Id"
WHERE "a"."Id" = "b"."Id"

Error: SQLite Error 1: 'no such column: a.Id'.

[roji]

Possibly a dup of #28886

[palhal]

I'm facing the same problem. I can work around it by making Animal.Id nullable, but that's often not an option. Making it nullable (int? vs int) produces a much more complicated (though valid) SQL.