haskell-beam / haskell-beam/beam
LEFT JOIN LATERAL support?
Open
- 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.