Room Database — Lessons learnt from working with multiple-table joins

In this article, I’m going to examine three methods of querying multiple tables at once, namely multi-table query, multi-map and @Relation-annotated data class and their pros & cons through a Q&A sample app. I’ll start by showing how to query answers for free text questions and then moves on to a more challenging use case: multiple-choice answers