PostgREST.QueryBuilder

This module provides functions to consume data types that represent database queries (e.g. ReadRequest, MutateRequest) and SqlFragment to produce SqlQuery type outputs.

Documentation

readRequestToQuery :: ReadRequest -> SqlQuery

mutateRequestToQuery :: MutateRequest -> SqlQuery

readRequestToCountQuery :: ReadRequest -> SqlQuery

SQL query meant for COUNTing the root node of the Tree. It only takes WHERE into account and doesn't include LIMIT/OFFSET because it would reduce the COUNT. SELECT 1 is done instead of SELECT * to prevent doing expensive operations(like functions based on the columns) inside the FROM target.

requestToCallProcQuery :: QualifiedIdentifier -> [PgArg] -> Bool -> Maybe PreferParameters -> [FieldName] -> SqlQuery

limitedQuery :: SqlQuery -> Maybe Integer -> SqlQuery

setLocalQuery :: Text -> (Text, Text) -> SqlQuery

setLocalSearchPathQuery :: [Text] -> SqlQuery