RevEng: Use alternate key when no primary key

[bricelam]

Mentioned in #5719 but got missed:

If there is no primary key defined, we could fallback to using a unique constraint/index if there is one.

And from #8840:

If a table in SQLite doesn't have an explicit primary key, the implicit rowid column can be used to uniquely identify a row. We should map the rowid column to a property in this case.

This would help unorthodox schemas like the ones in #18633 work better

[ice1e0]

This would be great; it would require that columns with nullable columns can be tracked, since unique constraints/indexes support nullable columns, primary keys don't nullable values; but maybe that requirement could be implemented with a separate issue.

[mt3sliv]

Any update on this?

[mt3sliv]

Any update on this?

I see it is on the backlog: #22948 is there any recommended work around until it is fixed? Cheers!

[DasNaughtie]

Any update on this or a workaround?

[ajcvickers]

@DasNaughtie Manually add the call to HasKey.