This matters because the parenthesized form is exactly how PostgreSQL's own deparser (pg_get_querydef / pg_get_viewdef, i.e. ruleutils) renders every join in the FROM clause. So any real PostgreSQL ...