LEFT JOIN { $_->cds, AS 'cd' }
ON { $_->cd->artistid eq $_->artist->id }
);
+DwarnL render_expr(
+ SELECT { $_->artist->name } WHERE { $_->artist->age > 25 }
+);
+DwarnL render_expr(
+ SELECT { $_->cd->name }
+ FROM { $_->cds, AS 'cd' }
+ JOIN { $_->artists, AS 'artist' }
+ ON { $_->cd->artistid eq $_->artist->id }
+ WHERE { $_->artist->age > 25 }
+);