3 ms·

I had the same question. From the docs, it looks pretty elegant: from employees join side:left positions (employees.id==positions.employee_id) which t

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

qorrect 3y ago
I like it too. You can also alias them easily from e=employees join p=positions (e.id==p.employee_id)
- trollied 3y ago
  positions p is a SQL alias. Was that too difficult?
  - kbenson 3y ago
    It's less about it being difficult, and more about it being easy, obvious to read/write, and consistent within the new design. Was that not obvious?
erezsh 3y ago
Except if I wrote it by hand, it would be - SELECT * FROM employees LEFT JOIN positions ON employees.id = positions.employee_id which isn't really that different.