Inherited by SqlBasicSelectQueryBuilder< SqlAllFieldsQueryBuilder< Record > >, SqlBasicSelectQueryBuilder< SqlSelectQueryBuilder >, SqlBasicSelectQueryBuilder< SqlSparseFieldQueryBuilder< Record, ReferencedFields... > >, and SqlBasicSelectQueryBuilder< Derived >.
|
| Derived & | And () noexcept |
| | Indicates, that the next WHERE clause should be AND-ed (default).
|
| |
| Derived & | Or () noexcept |
| | Indicates, that the next WHERE clause should be OR-ed.
|
| |
| Derived & | Not () noexcept |
| | Indicates, that the next WHERE clause should be negated.
|
| |
| Derived & | WhereRaw (std::string_view sqlConditionExpression) |
| | Constructs or extends a raw WHERE clause.
|
| |
|
template<typename ColumnName , typename T > |
| Derived & | Where (ColumnName const &columnName, std::string_view binaryOp, T const &value) |
| | Constructs or extends a WHERE clause to test for a binary operation.
|
| |
template<typename ColumnName , typename SubSelectQuery >
requires (std::is_invocable_r_v<std::string, decltype(&SubSelectQuery::ToSql), SubSelectQuery const&>) |
| Derived & | Where (ColumnName const &columnName, std::string_view binaryOp, SubSelectQuery const &value) |
| | Constructs or extends a WHERE clause to test for a binary operation for RHS as sub-select query.
|
| |
|
template<typename ColumnName , typename T > |
| Derived & | OrWhere (ColumnName const &columnName, std::string_view binaryOp, T const &value) |
| | Constructs or extends a WHERE/OR clause to test for a binary operation.
|
| |
|
template<typename ColumnName , std::size_t N> |
| Derived & | Where (ColumnName const &columnName, std::string_view binaryOp, char const (&value)[N]) |
| | Constructs or extends a WHERE clause to test for a binary operation for RHS as string literal.
|
| |
|
template<typename ColumnName , typename T > |
| Derived & | Where (ColumnName const &columnName, T const &value) |
| | Constructs or extends a WHERE clause to test for equality.
|
| |
|
template<typename ColumnName , typename T > |
| Derived & | OrWhere (ColumnName const &columnName, T const &value) |
| | Constructs or extends an WHERE/OR clause to test for equality.
|
| |
template<typename Callable >
requires std::invocable<Callable, SqlWhereClauseBuilder<Derived>&> |
| Derived & | Where (Callable const &callable) |
| | Constructs or extends a WHERE/AND clause to test for a group of values.
|
| |
template<typename Callable >
requires std::invocable<Callable, SqlWhereClauseBuilder<Derived>&> |
| Derived & | OrWhere (Callable const &callable) |
| | Constructs or extends an WHERE/OR clause to test for a group of values.
|
| |
|
template<typename ColumnName , std::ranges::input_range InputRange> |
| Derived & | WhereIn (ColumnName const &columnName, InputRange const &values) |
| | Constructs or extends an WHERE/OR clause to test for a value, satisfying std::ranges::input_range.
|
| |
|
template<typename ColumnName , typename T > |
| Derived & | WhereIn (ColumnName const &columnName, std::initializer_list< T > const &values) |
| | Constructs or extends an WHERE/OR clause to test for a value, satisfying std::initializer_list.
|
| |
template<typename ColumnName , typename SubSelectQuery >
requires (std::is_invocable_r_v<std::string, decltype(&SubSelectQuery::ToSql), SubSelectQuery const&>) |
| Derived & | WhereIn (ColumnName const &columnName, SubSelectQuery const &subSelectQuery) |
| | Constructs or extends an WHERE/OR clause to test for a value, satisfying a sub-select query.
|
| |
|
template<typename ColumnName > |
| Derived & | WhereNull (ColumnName const &columnName) |
| | Constructs or extends an WHERE/OR clause to test for a value to be NULL.
|
| |
|
template<typename ColumnName > |
| Derived & | WhereNotNull (ColumnName const &columnName) |
| | Constructs or extends a WHERE clause to test for a value being not null.
|
| |
|
template<typename ColumnName , typename T > |
| Derived & | WhereNotEqual (ColumnName const &columnName, T const &value) |
| | Constructs or extends a WHERE clause to test for a value being equal to another column.
|
| |
|
template<typename ColumnName > |
| Derived & | WhereTrue (ColumnName const &columnName) |
| | Constructs or extends a WHERE clause to test for a value being true.
|
| |
|
template<typename ColumnName > |
| Derived & | WhereFalse (ColumnName const &columnName) |
| | Constructs or extends a WHERE clause to test for a value being false.
|
| |
|
template<typename LeftColumn , typename RightColumn > |
| Derived & | WhereColumn (LeftColumn const &left, std::string_view binaryOp, RightColumn const &right) |
| | Construts or extends a WHERE clause to test for a binary operation between two columns.
|
| |
| Derived & | InnerJoin (std::string_view joinTable, std::string_view joinColumnName, SqlQualifiedTableColumnName onOtherColumn) |
| | Constructs an INNER JOIN clause.
|
| |
| Derived & | InnerJoin (std::string_view joinTable, std::string_view joinColumnName, std::string_view onMainTableColumn) |
| | Constructs an INNER JOIN clause.
|
| |
template<typename OnChainCallable >
requires std::invocable<OnChainCallable, SqlJoinConditionBuilder> |
| Derived & | InnerJoin (std::string_view joinTable, OnChainCallable const &onClauseBuilder) |
| | Constructs an INNER JOIN clause with a custom ON clause.
|
| |
| Derived & | LeftOuterJoin (std::string_view joinTable, std::string_view joinColumnName, SqlQualifiedTableColumnName onOtherColumn) |
| | Constructs an LEFT OUTER JOIN clause.
|
| |
| Derived & | LeftOuterJoin (std::string_view joinTable, std::string_view joinColumnName, std::string_view onMainTableColumn) |
| | Constructs an LEFT OUTER JOIN clause.
|
| |
template<typename OnChainCallable >
requires std::invocable<OnChainCallable, SqlJoinConditionBuilder> |
| Derived & | LeftOuterJoin (std::string_view joinTable, OnChainCallable const &onClauseBuilder) |
| | Constructs an LEFT OUTER JOIN clause with a custom ON clause.
|
| |
| Derived & | RightOuterJoin (std::string_view joinTable, std::string_view joinColumnName, SqlQualifiedTableColumnName onOtherColumn) |
| | Constructs an RIGHT OUTER JOIN clause.
|
| |
| Derived & | RightOuterJoin (std::string_view joinTable, std::string_view joinColumnName, std::string_view onMainTableColumn) |
| | Constructs an RIGHT OUTER JOIN clause.
|
| |
template<typename OnChainCallable >
requires std::invocable<OnChainCallable, SqlJoinConditionBuilder> |
| Derived & | RightOuterJoin (std::string_view joinTable, OnChainCallable const &onClauseBuilder) |
| | Constructs an RIGHT OUTER JOIN clause with a custom ON clause.
|
| |
| Derived & | FullOuterJoin (std::string_view joinTable, std::string_view joinColumnName, SqlQualifiedTableColumnName onOtherColumn) |
| | Constructs an FULL OUTER JOIN clause.
|
| |
| Derived & | FullOuterJoin (std::string_view joinTable, std::string_view joinColumnName, std::string_view onMainTableColumn) |
| | Constructs an FULL OUTER JOIN clause.
|
| |
template<typename OnChainCallable >
requires std::invocable<OnChainCallable, SqlJoinConditionBuilder> |
| Derived & | FullOuterJoin (std::string_view joinTable, OnChainCallable const &onClauseBuilder) |
| | Constructs an FULL OUTER JOIN clause with a custom ON clause.
|
| |
| template<typename ColumnName , typename T > |
| LIGHTWEIGHT_FORCE_INLINE Derived & | Where (ColumnName const &columnName, T const &value) |
| |
| template<typename ColumnName , typename T > |
| LIGHTWEIGHT_FORCE_INLINE Derived & | OrWhere (ColumnName const &columnName, T const &value) |
| |
template<typename Callable >
requires std::invocable<Callable, SqlWhereClauseBuilder<Derived>&> |
| LIGHTWEIGHT_FORCE_INLINE Derived & | OrWhere (Callable const &callable) |
| |
template<typename Callable >
requires std::invocable<Callable, SqlWhereClauseBuilder<Derived>&> |
| LIGHTWEIGHT_FORCE_INLINE Derived & | Where (Callable const &callable) |
| |
| template<typename ColumnName , std::ranges::input_range InputRange> |
| LIGHTWEIGHT_FORCE_INLINE Derived & | WhereIn (ColumnName const &columnName, InputRange const &values) |
| |
| template<typename ColumnName , typename T > |
| LIGHTWEIGHT_FORCE_INLINE Derived & | WhereIn (ColumnName const &columnName, std::initializer_list< T > const &values) |
| |
template<typename ColumnName , typename SubSelectQuery >
requires (std::is_invocable_r_v<std::string, decltype(&SubSelectQuery::ToSql), SubSelectQuery const&>) |
| LIGHTWEIGHT_FORCE_INLINE Derived & | WhereIn (ColumnName const &columnName, SubSelectQuery const &subSelectQuery) |
| |
| template<typename ColumnName > |
| LIGHTWEIGHT_FORCE_INLINE Derived & | WhereNotNull (ColumnName const &columnName) |
| |
| template<typename ColumnName > |
| LIGHTWEIGHT_FORCE_INLINE Derived & | WhereNull (ColumnName const &columnName) |
| |
| template<typename ColumnName , typename T > |
| LIGHTWEIGHT_FORCE_INLINE Derived & | WhereNotEqual (ColumnName const &columnName, T const &value) |
| |
| template<typename ColumnName > |
| LIGHTWEIGHT_FORCE_INLINE Derived & | WhereTrue (ColumnName const &columnName) |
| |
| template<typename ColumnName > |
| LIGHTWEIGHT_FORCE_INLINE Derived & | WhereFalse (ColumnName const &columnName) |
| |
| template<typename LeftColumn , typename RightColumn > |
| LIGHTWEIGHT_FORCE_INLINE Derived & | WhereColumn (LeftColumn const &left, std::string_view binaryOp, RightColumn const &right) |
| |
| template<typename ColumnName , std::size_t N> |
| LIGHTWEIGHT_FORCE_INLINE Derived & | Where (ColumnName const &columnName, std::string_view binaryOp, char const (&value)[N]) |
| |
| template<typename ColumnName , typename T > |
| LIGHTWEIGHT_FORCE_INLINE Derived & | Where (ColumnName const &columnName, std::string_view binaryOp, T const &value) |
| |
template<typename ColumnName , typename SubSelectQuery >
requires (std::is_invocable_r_v<std::string, decltype(&SubSelectQuery::ToSql), SubSelectQuery const&>) |
| LIGHTWEIGHT_FORCE_INLINE Derived & | Where (ColumnName const &columnName, std::string_view binaryOp, SubSelectQuery const &value) |
| |
| template<typename ColumnName , typename T > |
| LIGHTWEIGHT_FORCE_INLINE Derived & | OrWhere (ColumnName const &columnName, std::string_view binaryOp, T const &value) |
| |
template<typename ColumnName >
requires (std::same_as<ColumnName, SqlQualifiedTableColumnName> || std::convertible_to<ColumnName, std::string_view> || std::same_as<ColumnName, SqlRawColumnNameView> || std::convertible_to<ColumnName, std::string>) |
| LIGHTWEIGHT_FORCE_INLINE void | AppendColumnName (ColumnName const &columnName) |
| |
| template<typename LiteralType > |
| LIGHTWEIGHT_FORCE_INLINE void | AppendLiteralValue (LiteralType const &value) |
| |
| template<typename Callable > |
| LIGHTWEIGHT_FORCE_INLINE Derived & | Join (JoinType joinType, std::string_view joinTable, Callable const &onClauseBuilder) |
| |
1.9.8