PostgREST.QueryBuilder

This module provides functions to consume data types that represent database objects (e.g. Relation, Schema, SqlQuery) and produces SQL Statements.

Any function that outputs a SQL fragment should be in this module.

Documentation

addRelations :: Schema -> [Relation] -> Maybe ReadRequest -> ReadRequest -> Either Text ReadRequest

addJoinConditions :: Schema -> ReadRequest -> Either Text ReadRequest

asJson :: StatementT

callProc :: QualifiedIdentifier -> Object -> PStmt

createReadStatement :: SqlQuery -> Maybe NonnegRange -> Bool -> Bool -> Bool -> Stmt Postgres

createWriteStatement :: SqlQuery -> SqlQuery -> Bool -> Bool -> [Text] -> Bool -> Payload -> Stmt Postgres

operators :: [(Text, SqlFragment)]

pgFmtIdent :: SqlFragment -> SqlFragment

pgFmtLit :: SqlFragment -> SqlFragment

requestToQuery :: Schema -> DbRequest -> SqlQuery

sourceSubqueryName :: SqlFragment

unquoted :: Value -> Text