How are joins handled? A relational db is largely about the relations, otherwise this is more of a document query language.
from employees
join side:left positions (employees.id==positions.employee_id)
SELECT
employees.*,
positions.*
FROM
employees
LEFT JOIN positions ON employees.id = positions.employee_id from e=employees
join p=positions (e.id==p.employee_id)is a SQL alias. Was that too difficult?
SELECT *
FROM employees
LEFT JOIN positions ON employees.id = positions.employee_id