A simple thing would be macros for subqueries A := select col_1, col_2, col_3 fr...

im3w1l on May 10, 2019 | parent | context | favorite | on: We Can Do Better Than SQL

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