Unify "joins" and "get predicates" using existential subqueries #235
Labels
cleanup
Clean ups, refactorings, and code improvements that don't fall under other categories
Milestone
The current distinction of join vs get predicate is somewhat arbitrary as it depends on the direction that the connection between the table goes. The syntax is inconsistent, and get predicates are limited to only filters.
Let's clean that up, and let's use subquery syntax as that more closely matches the semantics of being a kind of filter that also looks at a different table. Also subqueries are clearly not commutative, unlike joins.
Strawman syntax:
and
(depending on the direction of the relation, restaurant -> review or review -> restaurant)
The text was updated successfully, but these errors were encountered: