With some syntax sugar it looks almost exactly like SQL [1]. Here I’m showing the unsweetened edition for didactic purposes.
movie.with(
company.s(country).eq("[us]"
)
.and(
keyword.eq("character-name-in-title")
)
.select(
title
.and(
cast.s(person).s(alias).s(text)
)
)