haskell-beam / haskell-beam/beam

LEFT JOIN LATERAL support?

Open
#547 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Haskell
Stars
635
Forks
193
PR merge metrics
No merged PRs in 30d

Description

Is it possible to construct a LEFT JOIN LATERAL query using beam? I've tried to combine `lateral_` and `leftJoin_` (and `subselect_`) in a few different ways but I couldn't figure out how to get the state threads to line up properly.

For reference, I'm looking to build a query like this:
```sql
SELECT request_json, real_ip
FROM request_logs
LEFT JOIN LATERAL jsonb_array_elements(request_logs.request_json->'headers') real_ip
ON real_ip->>0 ILIKE 'X-Real-IP';
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.