beam-core-0.10.3.0: Type-safe, feature-complete SQL query and manipulation interface for Haskell
Safe HaskellNone
LanguageHaskell2010

Database.Beam.Backend.SQL.Builder

Description

Provides a syntax SqlSyntaxBuilder that uses a Builder to construct SQL expressions as strings. Mainly serves as documentation for how to write a syntax for backends. Note that, although you can use this to turn most Q and QGenExprs into ByteString queries, it is very unwise to ship these to the database. This module does not take into account server-specific quoting. Some backends are very particular to quoting, and shipping arbitrary ByteStrings as queries can expose you to SQL injection vulnerabilities. Always use the provided backends to submit queries and data manipulation commands to the database.

Synopsis

Documentation

newtype SqlSyntaxBuilder Source #

The main syntax. A wrapper over Builder

Constructors

SqlSyntaxBuilder 

Fields

Instances

Instances details
IsSql2003ExpressionAdvancedOLAPOperationsSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Methods

percentRankAggE :: SqlSyntaxBuilder Source #

denseRankAggE :: SqlSyntaxBuilder Source #

cumeDistAggE :: SqlSyntaxBuilder Source #

IsSql2003ExpressionElementaryOLAPOperationsSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Methods

filterAggE :: SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

rankAggE :: SqlSyntaxBuilder Source #

IsSql2003ExpressionSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Associated Types

type Sql2003ExpressionWindowFrameSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql2003ExpressionWindowFrameSyntax SqlSyntaxBuilder = SqlSyntaxBuilder

Methods

overE :: SqlSyntaxBuilder -> Sql2003ExpressionWindowFrameSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

rowNumberE :: SqlSyntaxBuilder Source #

IsSql2003WindowFrameBoundsSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Associated Types

type Sql2003WindowFrameBoundsBoundSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql2003WindowFrameBoundsBoundSyntax SqlSyntaxBuilder

Methods

fromToBoundSyntax :: Sql2003WindowFrameBoundsBoundSyntax SqlSyntaxBuilder -> Maybe (Sql2003WindowFrameBoundsBoundSyntax SqlSyntaxBuilder) -> SqlSyntaxBuilder Source #

IsSql2003WindowFrameSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Associated Types

type Sql2003WindowFrameExpressionSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql2003WindowFrameExpressionSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql2003WindowFrameOrderingSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql2003WindowFrameOrderingSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql2003WindowFrameBoundsSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql2003WindowFrameBoundsSyntax SqlSyntaxBuilder = SqlSyntaxBuilder

Methods

frameSyntax :: Maybe [Sql2003WindowFrameExpressionSyntax SqlSyntaxBuilder] -> Maybe [Sql2003WindowFrameOrderingSyntax SqlSyntaxBuilder] -> Maybe (Sql2003WindowFrameBoundsSyntax SqlSyntaxBuilder) -> SqlSyntaxBuilder Source #

IsSql92AggregationExpressionSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Associated Types

type Sql92AggregationSetQuantifierSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92AggregationSetQuantifierSyntax SqlSyntaxBuilder = SqlSyntaxBuilder

Methods

countAllE :: SqlSyntaxBuilder Source #

countE :: Maybe (Sql92AggregationSetQuantifierSyntax SqlSyntaxBuilder) -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

avgE :: Maybe (Sql92AggregationSetQuantifierSyntax SqlSyntaxBuilder) -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

maxE :: Maybe (Sql92AggregationSetQuantifierSyntax SqlSyntaxBuilder) -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

minE :: Maybe (Sql92AggregationSetQuantifierSyntax SqlSyntaxBuilder) -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

sumE :: Maybe (Sql92AggregationSetQuantifierSyntax SqlSyntaxBuilder) -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

IsSql92AggregationSetQuantifierSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Methods

setQuantifierDistinct :: SqlSyntaxBuilder Source #

setQuantifierAll :: SqlSyntaxBuilder Source #

IsSql92DataTypeSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Methods

domainType :: Text -> SqlSyntaxBuilder Source #

charType :: Maybe Word -> Maybe Text -> SqlSyntaxBuilder Source #

varCharType :: Maybe Word -> Maybe Text -> SqlSyntaxBuilder Source #

nationalCharType :: Maybe Word -> SqlSyntaxBuilder Source #

nationalVarCharType :: Maybe Word -> SqlSyntaxBuilder Source #

bitType :: Maybe Word -> SqlSyntaxBuilder Source #

varBitType :: Maybe Word -> SqlSyntaxBuilder Source #

numericType :: Maybe (Word, Maybe Word) -> SqlSyntaxBuilder Source #

decimalType :: Maybe (Word, Maybe Word) -> SqlSyntaxBuilder Source #

intType :: SqlSyntaxBuilder Source #

smallIntType :: SqlSyntaxBuilder Source #

floatType :: Maybe Word -> SqlSyntaxBuilder Source #

doubleType :: SqlSyntaxBuilder Source #

realType :: SqlSyntaxBuilder Source #

dateType :: SqlSyntaxBuilder Source #

timeType :: Maybe Word -> Bool -> SqlSyntaxBuilder Source #

timestampType :: Maybe Word -> Bool -> SqlSyntaxBuilder Source #

IsSql92DeleteSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Associated Types

type Sql92DeleteTableNameSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92DeleteTableNameSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92DeleteExpressionSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92DeleteExpressionSyntax SqlSyntaxBuilder = SqlSyntaxBuilder

Methods

deleteStmt :: Sql92DeleteTableNameSyntax SqlSyntaxBuilder -> Maybe Text -> Maybe (Sql92DeleteExpressionSyntax SqlSyntaxBuilder) -> SqlSyntaxBuilder Source #

deleteSupportsAlias :: Proxy SqlSyntaxBuilder -> Bool Source #

IsSql92ExpressionSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Associated Types

type Sql92ExpressionQuantifierSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92ExpressionQuantifierSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92ExpressionValueSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92ExpressionValueSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92ExpressionSelectSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92ExpressionSelectSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92ExpressionFieldNameSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92ExpressionFieldNameSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92ExpressionCastTargetSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92ExpressionCastTargetSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92ExpressionExtractFieldSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92ExpressionExtractFieldSyntax SqlSyntaxBuilder = SqlSyntaxBuilder

Methods

valueE :: Sql92ExpressionValueSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

rowE :: [SqlSyntaxBuilder] -> SqlSyntaxBuilder Source #

quantifierListE :: [SqlSyntaxBuilder] -> SqlSyntaxBuilder Source #

coalesceE :: [SqlSyntaxBuilder] -> SqlSyntaxBuilder Source #

caseE :: [(SqlSyntaxBuilder, SqlSyntaxBuilder)] -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

fieldE :: Sql92ExpressionFieldNameSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

betweenE :: SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

andE :: SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

orE :: SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

addE :: SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

subE :: SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

mulE :: SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

divE :: SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

likeE :: SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

modE :: SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

overlapsE :: SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

nullIfE :: SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

positionE :: SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

eqE :: Maybe (Sql92ExpressionQuantifierSyntax SqlSyntaxBuilder) -> SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

neqE :: Maybe (Sql92ExpressionQuantifierSyntax SqlSyntaxBuilder) -> SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

ltE :: Maybe (Sql92ExpressionQuantifierSyntax SqlSyntaxBuilder) -> SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

gtE :: Maybe (Sql92ExpressionQuantifierSyntax SqlSyntaxBuilder) -> SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

leE :: Maybe (Sql92ExpressionQuantifierSyntax SqlSyntaxBuilder) -> SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

geE :: Maybe (Sql92ExpressionQuantifierSyntax SqlSyntaxBuilder) -> SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

eqMaybeE :: SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

neqMaybeE :: SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

castE :: SqlSyntaxBuilder -> Sql92ExpressionCastTargetSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

notE :: SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

negateE :: SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

isNullE :: SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

isNotNullE :: SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

isTrueE :: SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

isNotTrueE :: SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

isFalseE :: SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

isNotFalseE :: SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

isUnknownE :: SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

isNotUnknownE :: SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

charLengthE :: SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

octetLengthE :: SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

bitLengthE :: SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

lowerE :: SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

upperE :: SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

trimE :: SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

absE :: SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

extractE :: Sql92ExpressionExtractFieldSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

existsE :: Sql92ExpressionSelectSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

uniqueE :: Sql92ExpressionSelectSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

subqueryE :: Sql92ExpressionSelectSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

currentTimestampE :: SqlSyntaxBuilder Source #

defaultE :: SqlSyntaxBuilder Source #

inE :: SqlSyntaxBuilder -> [SqlSyntaxBuilder] -> SqlSyntaxBuilder Source #

inSelectE :: SqlSyntaxBuilder -> Sql92ExpressionSelectSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

IsSql92ExtractFieldSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Methods

secondsField :: SqlSyntaxBuilder Source #

minutesField :: SqlSyntaxBuilder Source #

hourField :: SqlSyntaxBuilder Source #

dayField :: SqlSyntaxBuilder Source #

monthField :: SqlSyntaxBuilder Source #

yearField :: SqlSyntaxBuilder Source #

IsSql92FieldNameSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Methods

qualifiedField :: Text -> Text -> SqlSyntaxBuilder Source #

unqualifiedField :: Text -> SqlSyntaxBuilder Source #

IsSql92FromSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Associated Types

type Sql92FromTableSourceSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92FromTableSourceSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92FromExpressionSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92FromExpressionSyntax SqlSyntaxBuilder = SqlSyntaxBuilder

Methods

fromTable :: Sql92FromTableSourceSyntax SqlSyntaxBuilder -> Maybe (Text, Maybe [Text]) -> SqlSyntaxBuilder Source #

innerJoin :: SqlSyntaxBuilder -> SqlSyntaxBuilder -> Maybe (Sql92FromExpressionSyntax SqlSyntaxBuilder) -> SqlSyntaxBuilder Source #

leftJoin :: SqlSyntaxBuilder -> SqlSyntaxBuilder -> Maybe (Sql92FromExpressionSyntax SqlSyntaxBuilder) -> SqlSyntaxBuilder Source #

rightJoin :: SqlSyntaxBuilder -> SqlSyntaxBuilder -> Maybe (Sql92FromExpressionSyntax SqlSyntaxBuilder) -> SqlSyntaxBuilder Source #

IsSql92GroupingSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Associated Types

type Sql92GroupingExpressionSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92GroupingExpressionSyntax SqlSyntaxBuilder = SqlSyntaxBuilder

Methods

groupByExpressions :: [Sql92GroupingExpressionSyntax SqlSyntaxBuilder] -> SqlSyntaxBuilder Source #

IsSql92InsertSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Associated Types

type Sql92InsertValuesSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92InsertValuesSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92InsertTableNameSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92InsertTableNameSyntax SqlSyntaxBuilder = SqlSyntaxBuilder

Methods

insertStmt :: Sql92InsertTableNameSyntax SqlSyntaxBuilder -> [Text] -> Sql92InsertValuesSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

IsSql92InsertValuesSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Associated Types

type Sql92InsertValuesExpressionSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92InsertValuesExpressionSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92InsertValuesSelectSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92InsertValuesSelectSyntax SqlSyntaxBuilder = SqlSyntaxBuilder

Methods

insertSqlExpressions :: [[Sql92InsertValuesExpressionSyntax SqlSyntaxBuilder]] -> SqlSyntaxBuilder Source #

insertFromSql :: Sql92InsertValuesSelectSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

IsSql92OrderingSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Associated Types

type Sql92OrderingExpressionSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92OrderingExpressionSyntax SqlSyntaxBuilder = SqlSyntaxBuilder

Methods

ascOrdering :: Sql92OrderingExpressionSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

descOrdering :: Sql92OrderingExpressionSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

IsSql92ProjectionSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Associated Types

type Sql92ProjectionExpressionSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92ProjectionExpressionSyntax SqlSyntaxBuilder = SqlSyntaxBuilder

Methods

projExprs :: [(Sql92ProjectionExpressionSyntax SqlSyntaxBuilder, Maybe Text)] -> SqlSyntaxBuilder Source #

IsSql92QuantifierSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Methods

quantifyOverAll :: SqlSyntaxBuilder Source #

quantifyOverAny :: SqlSyntaxBuilder Source #

IsSql92SchemaNameSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Methods

schemaName :: Text -> SqlSyntaxBuilder Source #

IsSql92SelectSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Associated Types

type Sql92SelectSelectTableSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92SelectSelectTableSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92SelectOrderingSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92SelectOrderingSyntax SqlSyntaxBuilder = SqlSyntaxBuilder

Methods

selectStmt :: Sql92SelectSelectTableSyntax SqlSyntaxBuilder -> [Sql92SelectOrderingSyntax SqlSyntaxBuilder] -> Maybe Integer -> Maybe Integer -> SqlSyntaxBuilder Source #

IsSql92SelectTableSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Associated Types

type Sql92SelectTableSelectSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92SelectTableSelectSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92SelectTableExpressionSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92SelectTableExpressionSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92SelectTableProjectionSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92SelectTableProjectionSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92SelectTableFromSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92SelectTableFromSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92SelectTableGroupingSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92SelectTableGroupingSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92SelectTableSetQuantifierSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92SelectTableSetQuantifierSyntax SqlSyntaxBuilder = SqlSyntaxBuilder

Methods

selectTableStmt :: Maybe (Sql92SelectTableSetQuantifierSyntax SqlSyntaxBuilder) -> Sql92SelectTableProjectionSyntax SqlSyntaxBuilder -> Maybe (Sql92SelectTableFromSyntax SqlSyntaxBuilder) -> Maybe (Sql92SelectTableExpressionSyntax SqlSyntaxBuilder) -> Maybe (Sql92SelectTableGroupingSyntax SqlSyntaxBuilder) -> Maybe (Sql92SelectTableExpressionSyntax SqlSyntaxBuilder) -> SqlSyntaxBuilder Source #

unionTables :: Bool -> SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

intersectTables :: Bool -> SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

exceptTable :: Bool -> SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

IsSql92Syntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Associated Types

type Sql92SelectSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92SelectSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92InsertSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92InsertSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92UpdateSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92UpdateSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92DeleteSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92DeleteSyntax SqlSyntaxBuilder = SqlSyntaxBuilder

Methods

selectCmd :: Sql92SelectSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

insertCmd :: Sql92InsertSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

updateCmd :: Sql92UpdateSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

deleteCmd :: Sql92DeleteSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

IsSql92TableNameSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Methods

tableName :: Maybe Text -> Text -> SqlSyntaxBuilder Source #

IsSql92TableSourceSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Associated Types

type Sql92TableSourceSelectSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92TableSourceSelectSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92TableSourceExpressionSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92TableSourceExpressionSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92TableSourceTableNameSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92TableSourceTableNameSyntax SqlSyntaxBuilder = SqlSyntaxBuilder

Methods

tableNamed :: Sql92TableSourceTableNameSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

tableFromSubSelect :: Sql92TableSourceSelectSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

tableFromValues :: [[Sql92TableSourceExpressionSyntax SqlSyntaxBuilder]] -> SqlSyntaxBuilder Source #

IsSql92UpdateSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Associated Types

type Sql92UpdateTableNameSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92UpdateTableNameSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92UpdateFieldNameSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92UpdateFieldNameSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92UpdateExpressionSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92UpdateExpressionSyntax SqlSyntaxBuilder = SqlSyntaxBuilder

Methods

updateStmt :: Sql92UpdateTableNameSyntax SqlSyntaxBuilder -> [(Sql92UpdateFieldNameSyntax SqlSyntaxBuilder, Sql92UpdateExpressionSyntax SqlSyntaxBuilder)] -> Maybe (Sql92UpdateExpressionSyntax SqlSyntaxBuilder) -> SqlSyntaxBuilder Source #

IsSql99ExpressionSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Methods

distinctE :: Sql92ExpressionSelectSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

similarToE :: SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

instanceFieldE :: SqlSyntaxBuilder -> Text -> SqlSyntaxBuilder Source #

refFieldE :: SqlSyntaxBuilder -> Text -> SqlSyntaxBuilder Source #

IsSql99FunctionExpressionSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Methods

functionCallE :: SqlSyntaxBuilder -> [SqlSyntaxBuilder] -> SqlSyntaxBuilder Source #

functionNameE :: Text -> SqlSyntaxBuilder Source #

IsCustomSqlSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Query.CustomSQL

Associated Types

newtype CustomSqlSyntax SqlSyntaxBuilder 
Instance details

Defined in Database.Beam.Query.CustomSQL

newtype CustomSqlSyntax SqlSyntaxBuilder = SqlSyntaxBuilderCustom ByteString

Methods

customExprSyntax :: CustomSqlSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source #

renderSyntax :: SqlSyntaxBuilder -> CustomSqlSyntax SqlSyntaxBuilder Source #

Monoid SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Methods

mempty :: SqlSyntaxBuilder #

mappend :: SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder #

mconcat :: [SqlSyntaxBuilder] -> SqlSyntaxBuilder #

Semigroup SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Methods

(<>) :: SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder #

sconcat :: NonEmpty SqlSyntaxBuilder -> SqlSyntaxBuilder #

stimes :: Integral b => b -> SqlSyntaxBuilder -> SqlSyntaxBuilder #

Show SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Methods

showsPrec :: Int -> SqlSyntaxBuilder -> ShowS #

show :: SqlSyntaxBuilder -> String #

showList :: [SqlSyntaxBuilder] -> ShowS #

Eq SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Methods

(==) :: SqlSyntaxBuilder -> SqlSyntaxBuilder -> Bool #

(/=) :: SqlSyntaxBuilder -> SqlSyntaxBuilder -> Bool #

Hashable SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Methods

hashWithSalt :: Int -> SqlSyntaxBuilder -> Int #

hash :: SqlSyntaxBuilder -> Int #

HasSqlValueSyntax SqlSyntaxBuilder SqlNull Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Methods

sqlValueSyntax :: SqlNull -> SqlSyntaxBuilder Source #

HasSqlValueSyntax SqlSyntaxBuilder Int32 Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Methods

sqlValueSyntax :: Int32 -> SqlSyntaxBuilder Source #

HasSqlValueSyntax SqlSyntaxBuilder Text Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Methods

sqlValueSyntax :: Text -> SqlSyntaxBuilder Source #

HasSqlValueSyntax SqlSyntaxBuilder Bool Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Methods

sqlValueSyntax :: Bool -> SqlSyntaxBuilder Source #

(TypeError (PreferExplicitSize Int Int32) :: Constraint) => HasSqlValueSyntax SqlSyntaxBuilder Int Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

Methods

sqlValueSyntax :: Int -> SqlSyntaxBuilder Source #

Monoid (CustomSqlSyntax SqlSyntaxBuilder) Source # 
Instance details

Defined in Database.Beam.Query.CustomSQL

Methods

mempty :: CustomSqlSyntax SqlSyntaxBuilder #

mappend :: CustomSqlSyntax SqlSyntaxBuilder -> CustomSqlSyntax SqlSyntaxBuilder -> CustomSqlSyntax SqlSyntaxBuilder #

mconcat :: [CustomSqlSyntax SqlSyntaxBuilder] -> CustomSqlSyntax SqlSyntaxBuilder #

Semigroup (CustomSqlSyntax SqlSyntaxBuilder) Source # 
Instance details

Defined in Database.Beam.Query.CustomSQL

Methods

(<>) :: CustomSqlSyntax SqlSyntaxBuilder -> CustomSqlSyntax SqlSyntaxBuilder -> CustomSqlSyntax SqlSyntaxBuilder #

sconcat :: NonEmpty (CustomSqlSyntax SqlSyntaxBuilder) -> CustomSqlSyntax SqlSyntaxBuilder #

stimes :: Integral b => b -> CustomSqlSyntax SqlSyntaxBuilder -> CustomSqlSyntax SqlSyntaxBuilder #

IsString (CustomSqlSyntax SqlSyntaxBuilder) Source # 
Instance details

Defined in Database.Beam.Query.CustomSQL

Methods

fromString :: String -> CustomSqlSyntax SqlSyntaxBuilder #

type Sql2003ExpressionWindowFrameSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql2003ExpressionWindowFrameSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql2003WindowFrameBoundsBoundSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql2003WindowFrameBoundsBoundSyntax SqlSyntaxBuilder
type Sql2003WindowFrameBoundsSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql2003WindowFrameBoundsSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql2003WindowFrameExpressionSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql2003WindowFrameExpressionSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql2003WindowFrameOrderingSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql2003WindowFrameOrderingSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92AggregationSetQuantifierSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92AggregationSetQuantifierSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92DeleteExpressionSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92DeleteExpressionSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92DeleteSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92DeleteSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92DeleteTableNameSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92DeleteTableNameSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92ExpressionCastTargetSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92ExpressionCastTargetSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92ExpressionExtractFieldSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92ExpressionExtractFieldSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92ExpressionFieldNameSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92ExpressionFieldNameSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92ExpressionQuantifierSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92ExpressionQuantifierSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92ExpressionSelectSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92ExpressionSelectSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92ExpressionValueSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92ExpressionValueSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92FromExpressionSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92FromExpressionSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92FromTableSourceSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92FromTableSourceSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92GroupingExpressionSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92GroupingExpressionSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92InsertSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92InsertSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92InsertTableNameSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92InsertTableNameSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92InsertValuesExpressionSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92InsertValuesExpressionSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92InsertValuesSelectSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92InsertValuesSelectSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92InsertValuesSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92InsertValuesSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92OrderingExpressionSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92OrderingExpressionSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92ProjectionExpressionSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92ProjectionExpressionSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92SelectOrderingSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92SelectOrderingSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92SelectSelectTableSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92SelectSelectTableSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92SelectSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92SelectSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92SelectTableExpressionSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92SelectTableExpressionSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92SelectTableFromSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92SelectTableFromSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92SelectTableGroupingSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92SelectTableGroupingSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92SelectTableProjectionSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92SelectTableProjectionSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92SelectTableSelectSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92SelectTableSelectSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92SelectTableSetQuantifierSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92SelectTableSetQuantifierSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92TableSourceExpressionSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92TableSourceExpressionSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92TableSourceSelectSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92TableSourceSelectSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92TableSourceTableNameSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92TableSourceTableNameSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92UpdateExpressionSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92UpdateExpressionSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92UpdateFieldNameSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92UpdateFieldNameSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92UpdateSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92UpdateSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92UpdateTableNameSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Backend.SQL.Builder

type Sql92UpdateTableNameSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
newtype CustomSqlSyntax SqlSyntaxBuilder Source # 
Instance details

Defined in Database.Beam.Query.CustomSQL

newtype CustomSqlSyntax SqlSyntaxBuilder = SqlSyntaxBuilderCustom ByteString

buildSepBy :: Builder -> [Builder] -> Builder Source #

quoteSql :: Text -> Builder Source #

renderSql :: SqlSyntaxBuilder -> String Source #