Function has_outer_join 

pub fn has_outer_join(sql: &str) -> bool

Returns true if the query’s outer FROM clause contains a JOIN. Run this instead of matching \bJOIN\b against the full SQL — matching against the full SQL false-positives on JOINs inside subqueries.