bitemyapp/esqueleto

Missing docs for SQL functions

Open

#93 opened on Jun 16, 2018

View on GitHub
 (5 comments) (0 reactions) (0 assignees)Haskell (106 forks)github user discovery
easyhelp wanted

Repository metrics

Stars
 (395 stars)
PR merge metrics
 (PR metrics pending)

Description

If I'm not missing something completely obvious, the core tutorial at https://www.stackage.org/haddock/lts-10.10/esqueleto-2.5.3/Database-Esqueleto.html doesn't really teach how to use SQL functions/expressions, such as date, random, now, substr, etc.

Coupled with the fact that the modules Database.Esqueleto.SQLite and Database.Esqueleto.MySQL don't show up in the package contents, I was under the impression that Esqueleto had absolutely no way to groupBy date(timestampCol) in SQLIte. After going through https://github.com/bitemyapp/esqueleto/blob/master/src/Database/Esqueleto/PostgreSQL.hs I realise that unsafeSQLFuntion is that escape hatch.

Contributor guide