No I didn’t have probelms and I’m using WHERE for example:
@Transaction @Query("SELECT * FROM videodata WHERE favorite = 1 ORDER BY lastTimePlayed")
fun getAllFavoriteVideos(): LiveData<List<VideoMetaData>>
VideoMetaData has relations. Are you sure your WHERE clause is valid in SQLite? Maybe it works with other SQL dialects / implementations but not in SQLite?