Support LATERAL subqueries with outer relation references outside WHERE clause

[neilconway]

Describe the bug

We only support LATERAL subqueries that reference the outer relation in their WHERE clause; we should expand this to support more queries.

To Reproduce

No response

Expected behavior

No response

Additional context

No response

[neilconway]

take