asterix-app/src/test/resources/AQLTS/queries-sql-like/WithFrom.aql

with $users := dataset('User')
from $user in $users
where some $i in $user.interests satisfies $i = "movies"
select { "name": $user.name }