Here's a roadmap for how I plan on tackling implementation of non-equi joins and arbitrary subqueries. Will start distributing some work out once I get the first few steps in! https://www.notion.so/Non-Equi-Join-Subquery-Plan-191091bd863480ffb92dcfab405587d3?pvs=4

Looks reasonable! Full steam ahead!