Kysoql
ReferenceAPI referenceInterfaces

SemiJoinSubqueryBuilder

Generated API reference for SemiJoinSubqueryBuilder in @kysoql/core.

@kysoql/core / SemiJoinSubqueryBuilder

Builder for the filtering portion of a semi-join subquery.

Extends

  • SemiJoinWhereBuilder<DB, TB, SemiJoinSubqueryBuilder<DB, OuterTB, OuterReference, TB>>

Type Parameters

Type Parameter
DB
OuterTB extends keyof DB
OuterReference extends string
TB extends keyof DB

Methods

$call()

$call<T>(func): T;

Passes this builder to func and returns the callback result.

Type Parameters

Type Parameter
T

Parameters

ParameterType
func(qb) => T

Returns

T


$if()

$if(condition, func): this;

Conditionally applies a builder callback; when false, the runtime query is unchanged.

Parameters

ParameterType
conditionboolean
func(qb) => this

Returns

this


clearWhere()

clearWhere(): this;

Returns a builder with the WHERE predicate removed.

Returns

this


select()

select<SE>(selection): SelectedSemiJoinSubqueryBuilder<DB, OuterTB, OuterReference, TB>;

Adds one or more typed selections to the query output.

Type Parameters

Type Parameter
SE extends string

Parameters

ParameterType
selectionSE & SemiJoinSelectionFieldName<DB, OuterTB, OuterReference, TB, SE>

Returns

SelectedSemiJoinSubqueryBuilder<DB, OuterTB, OuterReference, TB>


where()

Call Signature

where(expression): SemiJoinSubqueryBuilder;
Parameters
ParameterType
expressionWhereExpressionFactory<DB, TB, false>
Returns

SemiJoinSubqueryBuilder

Inherited from
SemiJoinWhereBuilder.where

Call Signature

where<RE, OP, RHS>(
   lhs,
   op,
   rhs
): SemiJoinSubqueryBuilder;
Type Parameters
Type Parameter
RE extends string
OP extends | "=" | "!=" | OrderedComparisonOperator | "in" | "not in" | MultiSelectComparisonOperator | "like"
RHS
Parameters
ParameterType
lhsRE & FilterableFieldName<DB, TB, RE>
opOP
rhsRHS
Returns

SemiJoinSubqueryBuilder

Inherited from
SemiJoinWhereBuilder.where

On this page