</span> 'streams.country))
      5)
     (<span class="org-builtin">:movie</span> 'name))))
</pre>
</div>
<p>
And a :left-join-lateral
</p>
<div class="org-src-container">
<pre class="src src-lisp">(query
   (<span class="org-builtin">:select</span> 'p.* (<span class="org-builtin">:as</span> 'dads.id 'dad-id) (<span class="org-builtin">:as</span> 'moms.id 'mom-id)
    <span class="org-builtin">:from</span> (<span class="org-builtin">:as</span> 'people 'p)
    <span class="org-builtin">:left-join-lateral</sp