Safe Haskell	None
Language	Haskell2010

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

newtype SqlSyntaxBuilder = SqlSyntaxBuilder {
- buildSql :: Builder
}
buildSepBy :: Builder -> [Builder] -> Builder
quoteSql :: Text -> Builder
renderSql :: SqlSyntaxBuilder -> String

Documentation

newtype SqlSyntaxBuilder Source #

The main syntax. A wrapper over Builder

Constructors

SqlSyntaxBuilder
Fields buildSql :: Builder

Instances

Eq SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder Methods (==) :: SqlSyntaxBuilder -> SqlSyntaxBuilder -> Bool # (/=) :: SqlSyntaxBuilder -> SqlSyntaxBuilder -> Bool #
Show SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder Methods showsPrec :: Int -> SqlSyntaxBuilder -> ShowS # show :: SqlSyntaxBuilder -> String # showList :: [SqlSyntaxBuilder] -> ShowS #
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 #
Monoid SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder Methods mempty :: SqlSyntaxBuilder # mappend :: SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder # mconcat :: [SqlSyntaxBuilder] -> SqlSyntaxBuilder #
Hashable SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder Methods hashWithSalt :: Int -> SqlSyntaxBuilder -> Int # hash :: SqlSyntaxBuilder -> Int #
IsSql92FromSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder Associated Types type Sql92FromTableSourceSyntax SqlSyntaxBuilder :: Type Source # type Sql92FromExpressionSyntax SqlSyntaxBuilder :: Type Source # 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 :: Type Source # Methods groupByExpressions :: [Sql92GroupingExpressionSyntax SqlSyntaxBuilder] -> SqlSyntaxBuilder Source #
IsSql92TableSourceSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder Associated Types type Sql92TableSourceSelectSyntax SqlSyntaxBuilder :: Type Source # type Sql92TableSourceExpressionSyntax SqlSyntaxBuilder :: Type Source # type Sql92TableSourceTableNameSyntax SqlSyntaxBuilder :: Type Source # Methods tableNamed :: Sql92TableSourceTableNameSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source # tableFromSubSelect :: Sql92TableSourceSelectSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source # tableFromValues :: [[Sql92TableSourceExpressionSyntax SqlSyntaxBuilder]] -> SqlSyntaxBuilder Source #
IsSql92TableNameSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder Methods tableName :: Maybe Text -> Text -> SqlSyntaxBuilder Source #
IsSql92OrderingSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder Associated Types type Sql92OrderingExpressionSyntax SqlSyntaxBuilder :: Type Source # 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 :: Type Source # Methods projExprs :: [(Sql92ProjectionExpressionSyntax SqlSyntaxBuilder, Maybe Text)] -> SqlSyntaxBuilder Source #
IsSql92AggregationSetQuantifierSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder Methods setQuantifierDistinct :: SqlSyntaxBuilder Source # setQuantifierAll :: SqlSyntaxBuilder Source #
IsSql92AggregationExpressionSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder Associated Types type Sql92AggregationSetQuantifierSyntax SqlSyntaxBuilder :: Type Source # 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 #
IsSql92ExpressionSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder Associated Types type Sql92ExpressionQuantifierSyntax SqlSyntaxBuilder :: Type Source # type Sql92ExpressionValueSyntax SqlSyntaxBuilder :: Type Source # type Sql92ExpressionSelectSyntax SqlSyntaxBuilder :: Type Source # type Sql92ExpressionFieldNameSyntax SqlSyntaxBuilder :: Type Source # type Sql92ExpressionCastTargetSyntax SqlSyntaxBuilder :: Type Source # type Sql92ExpressionExtractFieldSyntax SqlSyntaxBuilder :: Type Source # 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 #
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 #
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 #
IsSql92QuantifierSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder Methods quantifyOverAll :: SqlSyntaxBuilder Source # quantifyOverAny :: SqlSyntaxBuilder Source #
IsSql92FieldNameSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder Methods qualifiedField :: Text -> Text -> SqlSyntaxBuilder Source # unqualifiedField :: Text -> SqlSyntaxBuilder Source #
IsSql92DeleteSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder Associated Types type Sql92DeleteTableNameSyntax SqlSyntaxBuilder :: Type Source # type Sql92DeleteExpressionSyntax SqlSyntaxBuilder :: Type Source # Methods deleteStmt :: Sql92DeleteTableNameSyntax SqlSyntaxBuilder -> Maybe Text -> Maybe (Sql92DeleteExpressionSyntax SqlSyntaxBuilder) -> SqlSyntaxBuilder Source # deleteSupportsAlias :: Proxy SqlSyntaxBuilder -> Bool Source #
IsSql92UpdateSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder Associated Types type Sql92UpdateTableNameSyntax SqlSyntaxBuilder :: Type Source # type Sql92UpdateFieldNameSyntax SqlSyntaxBuilder :: Type Source # type Sql92UpdateExpressionSyntax SqlSyntaxBuilder :: Type Source # Methods updateStmt :: Sql92UpdateTableNameSyntax SqlSyntaxBuilder -> [(Sql92UpdateFieldNameSyntax SqlSyntaxBuilder, Sql92UpdateExpressionSyntax SqlSyntaxBuilder)] -> Maybe (Sql92UpdateExpressionSyntax SqlSyntaxBuilder) -> SqlSyntaxBuilder Source #
IsSql92InsertValuesSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder Associated Types type Sql92InsertValuesExpressionSyntax SqlSyntaxBuilder :: Type Source # type Sql92InsertValuesSelectSyntax SqlSyntaxBuilder :: Type Source # Methods insertSqlExpressions :: [[Sql92InsertValuesExpressionSyntax SqlSyntaxBuilder]] -> SqlSyntaxBuilder Source # insertFromSql :: Sql92InsertValuesSelectSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source #
IsSql92InsertSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder Associated Types type Sql92InsertValuesSyntax SqlSyntaxBuilder :: Type Source # type Sql92InsertTableNameSyntax SqlSyntaxBuilder :: Type Source # Methods insertStmt :: Sql92InsertTableNameSyntax SqlSyntaxBuilder -> [Text] -> Sql92InsertValuesSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source #
IsSql92SelectTableSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder Associated Types type Sql92SelectTableSelectSyntax SqlSyntaxBuilder :: Type Source # type Sql92SelectTableExpressionSyntax SqlSyntaxBuilder :: Type Source # type Sql92SelectTableProjectionSyntax SqlSyntaxBuilder :: Type Source # type Sql92SelectTableFromSyntax SqlSyntaxBuilder :: Type Source # type Sql92SelectTableGroupingSyntax SqlSyntaxBuilder :: Type Source # type Sql92SelectTableSetQuantifierSyntax SqlSyntaxBuilder :: Type Source # 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 #
IsSql92SelectSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder Associated Types type Sql92SelectSelectTableSyntax SqlSyntaxBuilder :: Type Source # type Sql92SelectOrderingSyntax SqlSyntaxBuilder :: Type Source # Methods selectStmt :: Sql92SelectSelectTableSyntax SqlSyntaxBuilder -> [Sql92SelectOrderingSyntax SqlSyntaxBuilder] -> Maybe Integer -> Maybe Integer -> SqlSyntaxBuilder Source #
IsSql92Syntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder Associated Types type Sql92SelectSyntax SqlSyntaxBuilder :: Type Source # type Sql92InsertSyntax SqlSyntaxBuilder :: Type Source # type Sql92UpdateSyntax SqlSyntaxBuilder :: Type Source # type Sql92DeleteSyntax SqlSyntaxBuilder :: Type Source # Methods selectCmd :: Sql92SelectSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source # insertCmd :: Sql92InsertSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source # updateCmd :: Sql92UpdateSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source # deleteCmd :: Sql92DeleteSyntax 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 #
IsSql2003WindowFrameBoundsSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder Associated Types type Sql2003WindowFrameBoundsBoundSyntax SqlSyntaxBuilder :: Type Source # 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 :: Type Source # type Sql2003WindowFrameOrderingSyntax SqlSyntaxBuilder :: Type Source # type Sql2003WindowFrameBoundsSyntax SqlSyntaxBuilder :: Type Source # Methods frameSyntax :: Maybe [Sql2003WindowFrameExpressionSyntax SqlSyntaxBuilder] -> Maybe [Sql2003WindowFrameOrderingSyntax SqlSyntaxBuilder] -> Maybe (Sql2003WindowFrameBoundsSyntax SqlSyntaxBuilder) -> SqlSyntaxBuilder Source #
IsSql2003ExpressionElementaryOLAPOperationsSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder Methods filterAggE :: SqlSyntaxBuilder -> SqlSyntaxBuilder -> SqlSyntaxBuilder Source # rankAggE :: SqlSyntaxBuilder Source #
IsSql2003ExpressionAdvancedOLAPOperationsSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder Methods percentRankAggE :: SqlSyntaxBuilder Source # denseRankAggE :: SqlSyntaxBuilder Source # cumeDistAggE :: SqlSyntaxBuilder Source #
IsSql2003ExpressionSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder Associated Types type Sql2003ExpressionWindowFrameSyntax SqlSyntaxBuilder :: Type Source # Methods overE :: SqlSyntaxBuilder -> Sql2003ExpressionWindowFrameSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source # rowNumberE :: SqlSyntaxBuilder Source #
IsCustomSqlSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Query.CustomSQL Associated Types data CustomSqlSyntax SqlSyntaxBuilder :: Type Source # Methods customExprSyntax :: CustomSqlSyntax SqlSyntaxBuilder -> SqlSyntaxBuilder Source # renderSyntax :: SqlSyntaxBuilder -> CustomSqlSyntax SqlSyntaxBuilder Source #
HasSqlValueSyntax SqlSyntaxBuilder Bool Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder Methods sqlValueSyntax :: Bool -> SqlSyntaxBuilder Source #
HasSqlValueSyntax SqlSyntaxBuilder Int Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder Methods sqlValueSyntax :: Int -> 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 SqlNull Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder Methods sqlValueSyntax :: SqlNull -> SqlSyntaxBuilder Source #
IsString (CustomSqlSyntax SqlSyntaxBuilder) Source #
Instance details Defined in Database.Beam.Query.CustomSQL Methods fromString :: String -> 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 #
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 #
type Sql92FromTableSourceSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql92FromTableSourceSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92FromExpressionSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql92FromExpressionSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92GroupingExpressionSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql92GroupingExpressionSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92TableSourceSelectSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql92TableSourceSelectSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92TableSourceExpressionSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql92TableSourceExpressionSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92TableSourceTableNameSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql92TableSourceTableNameSyntax 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 Sql92AggregationSetQuantifierSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql92AggregationSetQuantifierSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92ExpressionQuantifierSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql92ExpressionQuantifierSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92ExpressionValueSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql92ExpressionValueSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92ExpressionSelectSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql92ExpressionSelectSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92ExpressionFieldNameSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql92ExpressionFieldNameSyntax 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 Sql92DeleteTableNameSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql92DeleteTableNameSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92DeleteExpressionSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql92DeleteExpressionSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92UpdateTableNameSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql92UpdateTableNameSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92UpdateFieldNameSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql92UpdateFieldNameSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92UpdateExpressionSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql92UpdateExpressionSyntax 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 Sql92InsertTableNameSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql92InsertTableNameSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92SelectTableSelectSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql92SelectTableSelectSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92SelectTableExpressionSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql92SelectTableExpressionSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92SelectTableProjectionSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql92SelectTableProjectionSyntax 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 Sql92SelectTableSetQuantifierSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql92SelectTableSetQuantifierSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92SelectSelectTableSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql92SelectSelectTableSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92SelectOrderingSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql92SelectOrderingSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92SelectSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql92SelectSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92InsertSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql92InsertSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92UpdateSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql92UpdateSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql92DeleteSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql92DeleteSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql2003WindowFrameBoundsBoundSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql2003WindowFrameBoundsBoundSyntax 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 Sql2003WindowFrameBoundsSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql2003WindowFrameBoundsSyntax SqlSyntaxBuilder = SqlSyntaxBuilder
type Sql2003ExpressionWindowFrameSyntax SqlSyntaxBuilder Source #
Instance details Defined in Database.Beam.Backend.SQL.Builder type Sql2003ExpressionWindowFrameSyntax 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 #

Key	Shortcut
s	Open this search box
esc	Close this search box
↓,ctrl + j	Move down in search results
↑,ctrl + k	Move up in search results
↵	Go to active search result