PostgresqlSyntax.Rendering

Execution

toByteString :: Builder -> ByteString

toText :: Builder -> Text

Helpers

commaNonEmpty :: (a -> Builder) -> NonEmpty a -> Builder

spaceNonEmpty :: (a -> Builder) -> NonEmpty a -> Builder

lexemes :: [Builder] -> Builder

optLexemes :: [Maybe Builder] -> Builder

inParens :: Builder -> Builder

inBrackets :: Builder -> Builder

prefixMaybe :: (a -> Builder) -> Maybe a -> Builder

suffixMaybe :: (a -> Builder) -> Maybe a -> Builder

Statements

preparableStmt :: PreparableStmt -> Builder

Call

callStmt :: CallStmt -> Builder

Insert

insertStmt :: InsertStmt -> Builder

insertTarget :: InsertTarget -> Builder

insertRest :: InsertRest -> Builder

insertRestOverriding :: (Semigroup a, IsString a) => OverrideKind -> a

overrideKind :: IsString a => OverrideKind -> a

insertColumnList :: InsertColumnList -> Builder

insertColumnItem :: InsertColumnItem -> Builder

onConflict :: OnConflict -> Builder

onConflictDo :: OnConflictDo -> Builder

confExpr :: ConfExpr -> Builder

returningClause :: ReturningClause -> Builder

Update

updateStmt :: UpdateStmt -> Builder

setClauseList :: SetClauseList -> Builder

setClause :: SetClause -> Builder

setTarget :: SetTarget -> Builder

setTargetList :: SetTargetList -> Builder

Delete

deleteStmt :: DeleteStmt -> Builder

usingClause :: UsingClause -> Builder

Select

selectStmt :: SelectStmt -> Builder

selectNoParens :: SelectNoParens -> Builder

selectWithParens :: SelectWithParens -> Builder

withClause :: WithClause -> Builder

commonTableExpr :: CommonTableExpr -> Builder

materialization :: IsString a => Bool -> a

selectLimit :: SelectLimit -> Builder

limitClause :: LimitClause -> Builder

firstOrNext :: IsString a => Bool -> a

rowOrRows :: IsString a => Bool -> a

selectFetchFirstValue :: SelectFetchFirstValue -> Builder

intOrFloat :: Either Int64 Double -> Builder

selectLimitValue :: SelectLimitValue -> Builder

offsetClause :: OffsetClause -> Builder

forLockingClause :: ForLockingClause -> Builder

forLockingItem :: ForLockingItem -> Builder

forLockingStrength :: IsString a => ForLockingStrength -> a

lockedRelsList :: NonEmpty QualifiedName -> Builder

nowaitOrSkip :: IsString a => Bool -> a

selectClause :: SelectClause -> Builder

simpleSelect :: SimpleSelect -> Builder

selectBinOp :: IsString a => SelectBinOp -> a

targeting :: Targeting -> Builder

targetList :: ReturningClause -> Builder

onExpressionsClause :: ExprList -> Builder

targetEl :: TargetEl -> Builder

Select Into

intoClause :: IntoClause -> Builder

optTempTableName :: IntoClause -> Builder

From

fromClause :: FromClause -> Builder

fromList :: FromClause -> Builder

tableRef :: TableRef -> Builder

relationExpr :: RelationExpr -> Builder

relationExprOptAlias :: RelationExprOptAlias -> Builder

optAlias :: (Bool, Ident) -> Builder

tablesampleClause :: TablesampleClause -> Builder

repeatableClause :: RepeatableClause -> Builder

funcTable :: FuncTable -> Builder

rowsfromItem :: RowsfromItem -> Builder

rowsfromList :: RowsfromList -> Builder

colDefList :: ColDefList -> Builder

tableFuncElementList :: ColDefList -> Builder

tableFuncElement :: TableFuncElement -> Builder

collateClause :: AnyName -> Builder

aliasClause :: AliasClause -> Builder

funcAliasClause :: FuncAliasClause -> Builder

joinedTable :: JoinedTable -> Builder

joinType :: (Semigroup a, IsString a) => JoinType -> a

joinQual :: JoinQual -> Builder

Where

whereClause :: WhereClause -> Builder

whereOrCurrentClause :: WhereOrCurrentClause -> Builder

Group By

groupClause :: GroupClause -> Builder

groupByItem :: GroupByItem -> Builder

Having

havingClause :: HavingClause -> Builder

Window

windowClause :: WindowClause -> Builder

windowDefinition :: WindowDefinition -> Builder

windowSpecification :: WindowSpecification -> Builder

partitionClause :: PartitionClause -> Builder

frameClause :: FrameClause -> Builder

frameClauseMode :: IsString a => FrameClauseMode -> a

frameExtent :: FrameExtent -> Builder

frameBound :: FrameBound -> Builder

windowExclusionCause :: IsString a => WindowExclusionClause -> a

Order By

sortClause :: SortClause -> Builder

sortBy :: SortBy -> Builder

Values

valuesClause :: ValuesClause -> Builder

Exprs

exprList :: ExprList -> Builder

aExpr :: AExpr -> Builder

bExpr :: BExpr -> Builder

cExpr :: CExpr -> Builder

Ops

aExprReversableOp :: Bool -> AExprReversableOp -> Builder

verbalExprBinOp :: (Monoid b, IsString b) => Bool -> VerbalExprBinOp -> b

subqueryOp :: SubqueryOp -> Builder

bExprIsOp :: Bool -> BExprIsOp -> Builder

symbolicExprBinOp :: SymbolicExprBinOp -> Builder

qualOp :: QualOp -> Builder

qualAllOp :: QualAllOp -> Builder

op :: Text -> Builder

anyOperator :: AnyOperator -> Builder

allOp :: AllOp -> Builder

mathOp :: MathOp -> Builder

inExpr :: InExpr -> Builder

caseExpr :: CaseExpr -> Builder

whenClause :: WhenClause -> Builder

caseDefault :: CaseDefault -> Builder

arrayExpr :: ArrayExpr -> Builder

arrayExprList :: ArrayExprList -> Builder

row :: Row -> Builder

explicitRow :: ExplicitRow -> Builder

implicitRow :: ImplicitRow -> Builder

funcApplication :: FuncApplication -> Builder

funcApplicationParams :: FuncApplicationParams -> Builder

allOrDistinct :: IsString a => Bool -> a

funcArgExpr :: FuncArgExpr -> Builder

Func Expr

funcExpr :: FuncExpr -> Builder

funcExprWindownless :: FuncExprWindowless -> Builder

withinGroupClause :: WithinGroupClause -> Builder

filterClause :: FilterClause -> Builder

overClause :: OverClause -> Builder

funcExprCommonSubexpr :: FuncExprCommonSubexpr -> Builder

extractList :: ExtractList -> Builder

extractArg :: ExtractArg -> Builder

overlayList :: OverlayList -> Builder

overlayPlacing :: OverlayPlacing -> Builder

positionList :: PositionList -> Builder

substrList :: SubstrList -> Builder

substrListFromFor :: SubstrListFromFor -> Builder

substrFrom :: SubstrFrom -> Builder

substrFor :: SubstrFor -> Builder

trimModifier :: IsString a => TrimModifier -> a

trimList :: TrimList -> Builder

AexprConsts

aexprConst :: AexprConst -> Builder

iconst :: Int64 -> Builder

fconst :: Double -> Builder

sconst :: Text -> Builder

funcAexprConstArgList :: FuncConstArgs -> Builder

constTypename :: ConstTypename -> Builder

numeric :: Numeric -> Builder

bit :: Bit -> Builder

constBit :: ConstBit -> Builder

constCharacter :: ConstCharacter -> Builder

character :: (Semigroup a, IsString a) => Character -> a

constDatetime :: ConstDatetime -> Builder

timezone :: IsString a => Bool -> a

interval :: Interval -> Builder

intervalSecond :: Maybe Int64 -> Builder

Names and refs

columnref :: Columnref -> Builder

ident :: Ident -> Builder

qualifiedName :: QualifiedName -> Builder

indirection :: Indirection -> Builder

indirectionEl :: IndirectionEl -> Builder

colId :: Ident -> Builder

name :: Ident -> Builder

cursorName :: Ident -> Builder

colLabel :: Ident -> Builder

attrName :: Ident -> Builder

typeFunctionName :: Ident -> Builder

funcName :: FuncName -> Builder

anyName :: AnyName -> Builder

Types

typename :: Typename -> Builder

typenameArrayDimensionsWithQuestionMark :: (TypenameArrayDimensions, b) -> Builder

typenameArrayDimensions :: TypenameArrayDimensions -> Builder

arrayBounds :: Foldable t => NonEmpty (t Int64) -> Builder

simpleTypename :: SimpleTypename -> Builder

genericType :: GenericType -> Builder

attrs :: Foldable t => t Ident -> Builder

typeModifiers :: TypeModifiers -> Builder

typeList :: TypeList -> Builder

subType :: IsString a => SubType -> a

Indexes

indexParams :: NonEmpty IndexElem -> Builder

indexElem :: IndexElem -> Builder

indexElemDef :: IndexElemDef -> Builder

collate :: AnyName -> Builder

class_ :: AnyName -> Builder

ascDesc :: IsString a => AscDesc -> a

nullsOrder :: IsString a => NullsOrder -> a