bitemyapp / bitemyapp/esqueleto
Support [NOT] MATERIALIZED keyword for WITH queries/CTEs
Open
- Dominant language
- Haskell
- Stars
- 399
- Forks
- 107
- Avg merge
- 1d 17h
- Merged PRs (30d)
- 1
Description
As mentioned in the esquelto docs (https://hackage.haskell.org/package/esqueleto-3.5.8.1/docs/Database-Esqueleto-Experimental-From-CommonTableExpression.html), postgres (>12) supports keywords which specifies that CTEs should be fully calculated/materialized. For us, this is a must for performance reasons.
It would be great if there was some way to do this in esquelto, so that we could use it everywhere instead of having to use `sqlQQ` in cases where we need to specify CTEs should be materialized.
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.