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

data Relation p r

relation

aggregateRelation

data UpdateTarget p r

updateTarget

data Restriction p r

restriction

Projection

Projection Type

data Projection c t

data Flat

data Aggregated

data Exists

data OverWindow

Projection Path

data Pi r0 r1

(!)

(<.>)

Projection Operators

value

values

(.=.)

(.<.)

(.<=.)

(.>.)

(.>=.)

(.<>.)

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'

updateTarget'

restriction'

union'

Database Statements

relationalQuery

typedInsert

typedUpdate

typedDelete

typedKeyUpdate

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