bitemyapp / bitemyapp/esqueleto

`From` is a baffling name for the result of a CTE

Open
#429 4 comments 1 reaction 0 assignees View on GitHub
Dominant language
Haskell
Stars
399
Forks
107
Avg merge
1d 17h
Merged PRs (30d)
1

Description

I am filing this issue in light of some oopsies we did in production, because it's not very obvious when a value is a CTE versus a subquery and that these look basically the same and can be easily mixed up. If this is combined with reusing the query in multiple places, e.g. `let x = someQuery; y <- from x` vs `x <- with someQuery; y <- from x`, it can be really easy to accidentally cause a multiplicative blowup of the size of the output query without noticing that it's a subquery instead of a CTE.

I am not sure what the *solution* to this is, but it's an API footgun.

cc @ellie-hg @parsonsmatt

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.