let us say I have //roomdb
@Query("SELECT * FROM Dog")
fun getAllDogs(): Flow<List<Dog>>
// getDogDetails
suspend fun getDogDetils(id:Int) :DogDetails
I want to hit endpoint to get dog details, however room,sqldelight return Flow<List> as Oneshot, I want to call getDogDetils for all dogs async and return the result as Flow<List<DogDetails>>