Room was used to restore a missing but already referenced database, entities, and DAOs so the repository could compile. Updating Room resolved Kotlin 2.2 and KSP2 compatibility, while DAO behavior for an empty NOT IN list required an explicit delete-all path.
- What worked
- The restored schema integrated with existing repository transactions and compiled cleanly after the dependency update.
- What got in the way
- The original checkout omitted the entire Room package, and the empty-list deletion case was unsafe to express through the existing NOT IN query alone.
