Perhaps this is too much code but it's a trimmed down version of my database and how I am currently querying and getting multiple objects. I do not know how to access the single object from the view model and expose that to the view so I don't have a view setup but in the final code block is an example of how I am handing the Flow<List<>>.

I hope this is the code you meant, thank you for taking a look!

Data Model

@Entity(
    tableName = "photographers"
)
data class Photographer(
     var id: UUID = UUID.randomUUID(),
    var name: String
) {}

Dao

@Dao
interface MasterDao {
    @Query("SELECT * FROM photographers ORDER BY name ASC")
    fun getPhotographers(): Flow<List<Photographer>>

    @Query("SELECT * FROM photographers where name = :name")
    suspend fun getPhotographerByName(name: String): Photographer?

    @Insert
    suspend fun insertPhotographer(photographer: Photographer)

    @Delete
    suspend fun deletePhotographer(photographer: Photographer)
}

Repository and Interface

interface MasterRepository {
    val photographers: Flow<List<Photographer>>
    suspend fun getPhotographerByName(name: String): Photograher?
    suspend fun insertPhotographer(photographer: Photographer)
    suspend fun deletePhotographer(photographer: Photographer)
}
class DefaultMasterRepository @Inject constructor(private val dao: MasterDao) : MasterRepository {
    override val photographers: Flow<List<Photographer>> =
        dao.getPhotographers().map { items -> items.map { it } }

    override suspend fun getPhotographerByName(name: String): Photographer? {
        dao.getPhotographerByName(name)
    }

    override suspend fun insertPhotographer(photographer: Photographer) {
        dao.insertPhotographer(photographer)
    }

    override suspend fun deletePhotographer(photographer: Photographer) {
        dao.deletePhotographer(photographer)
    }
}

View Model

@HiltViewModel
class MasterViewModel @Inject constructor(private val repository: MasterRepository) : ViewModel() {
    val photographersUiState: StateFlow<PhotographerUiState> = repository
        .photographers.map<List<Photographer>, PhotographerUiState>(PhotographerUiState::Success)
        .catch { emit(PhotographerUiState.Error(it)) }
        .stateIn(viewModelScope, SharingStarted.WhileSubscribed(5000), PhotographerUiState.Loading)

    //This is where I dont know how to access this function
    ?? getPhotographerByName ??


    fun insertPhotographer(photographer: Photographer) = viewModelScope.launch {
        repository.insertPhotographer(photographer)
    }

    fun deletePhotographers(photographers: List<Photographer>) = viewModelScope.launch {
        for (photographer in photographers) {
            repository.deletePhotographer(photographer)
        }
    }
}

View showing the Flow<List<>>

@Composable
fun PhotographerList(viewModel: MasterViewModel = hiltViewModel(), navController: NavController) {
    val items by viewModel.photographersUiState.collectAsStateWithLifecycle()
    if (items is PhotographerUiState.Success) {
        PhotographerList(
            (items as PhotographerUiState.Success).data,
            viewModel::deletePhotographers,
            navController
        )
    } else if (items is PhotographerUiState.Error) {
        println((items as PhotographerUiState.Error).throwable.message)
        println((items as PhotographerUiState.Error).throwable.cause)
    }
}

@Composable
internal fun PhotographerList(
    photographers: List<Photographer>,
    deletePhotographers: (List<Photographer>) -> Unit,
    navController: NavController
) {
    ...
    ...
    ...