More concise SQL for joins · Issue #2333 · tidyverse/dplyr

using table aliases (#1997 (comment)): left_join(memdb_frame(a=1, b=1), memdb_frame(b=1, c=1)) %>% sql_render() should be rendered as SELECT 'a', 'LEFT'.'b', 'c' FROM 'df1' AS 'LEFT' LEFT JOIN...