Query models

@Query types are not tables. They only map a SELECT onto a class.

@Query
data class AuthorNameQuery(
    val blogName: String,
    val authorId: Int,
    val blogId: Int,
)

@Database(version = 1, tables = [Author::class, Blog::class], queries = [AuthorNameQuery::class])
abstract class AppDatabase : DBFlowDatabase<AppDatabase>() {
    abstract val blogAdapter: ModelAdapter<Blog>
    abstract val authorAdapter: ModelAdapter<Author>
    abstract val authorNameQueryAdapter: QueryAdapter<AuthorNameQuery>
}

db.readableTransaction {
    (blogAdapter.select(
        Blog.name.withTable() `as` "blogName",
        Blog.author_id.withTable() `as` "authorId",
        Blog.id.withTable() `as` "blogId",
    ) innerJoin authorAdapter
        on (Blog.author_id.withTable() eq Author.id.withTable()))
        .list(authorNameQueryAdapter)
}

@QueryModel is a deprecated alias of @Query.