I had the same question. From the docs, it looks pretty elegant:

    from employees
    join side:left positions (employees.id==positions.employee_id)

which translates to

    SELECT
      employees.*,
      positions.*
    FROM
      employees
      LEFT JOIN positions ON employees.id = positions.employee_id