Database.Relational.Query.Documentation

Concepts

Relational Query Building DSL

Monadic Query Context Building

Monadic Operators

query

queryMaybe

on

wheres

groupBy

having

Direct Join Operators

inner

left

right

full

on'

Finalize Context

relation

aggregateRelation

Projection Operators

(.=.)

(.<.)

(.<=.)

(.>.)

(.>=.)

(.<>.)

casesOrElse

case'

in'

and'

or'

isNothing

isJust

fromMaybe

not'

exists

(.||.)

(.+.)

(.-.)

(./.)

(.*.)

negate'

fromIntegral'

showNum

Aggregate and Window Functions

sum'

avg

max'

min'

every

any'

some'

rank

denseRank

rowNumber

percentRank

cumeDist

Set Operators

union

except

intersect

Maybe Projections

(?+?)

negateMaybe

sumMaybe

Placeholders

query'

left'

relation'

union'

Database Operations

Generalized Statement

prepareNoFetch

bind

execute

executeNoFetch

Select

prepareQuery

fetch

runQuery

Insert Values

prepareInsert

runInsert

Insert Select Results

prepareInsertQuery

runInsertQuery

Update

prepareUpdate

runUpdate

Delete

prepareDelete

runDelete

Update by Key

prepareKeyUpdate

bindKeyUpdate

runKeyUpdate