my $sql = $builder->build_sql(
    select => [
        'A.foo',
        'E.bar',
    ],
    where => [
        'D.abcd = ?',
    ],
);

##</code><code>##

SELECT A.foo, E.bar
  FROM A join B using (ab) join D using (bd) join E using (de)
 WHERE D.abcd = ?