3 ms·

How are joins handled? A relational db is largely about the relations, otherwise this is more of a document query language.

• athenot 3y ago
  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.