In addition to supporting migrations of table schema (T75808), it should also be possible to migrate the storage backend-specific implementation of schemas. This will require that a _backend-version attribute be assigned (by the backend itself), so that version mismatches can trigger whatever changes are necessary.
As a use-case, the current ad-hoc dropping of the native secondary index on _domain should be converted to use this mechanism.