Comment by im3w1l

A simple thing would be macros for subqueries

    A := select col_1, col_2, col_3 from table_1
    B := select col_4, col_5, col_6 from table_2 where 2*col_5 > col_4 + col_6
    $A left join $B on table_1.col_1 = table_2.col_5