Module litebridge.orm
Package org.litebridgedb.orm.api.select

Interface JoinClauseTerminal<DTO,JC extends JoinClause<DTO,JCC,JCCT>,JCC extends JoinConditionClause<DTO,JCC,JCCT>,JCCT extends JoinConditionClauseTerminal<DTO,JCC,JCCT>,WCC extends WhereConditionClause<DTO,WCC,WCCT,GBCT,HCC,HCCT,OBC,OBCC>,WCCT extends WhereConditionClauseTerminal<DTO,WCC,WCCT,GBCT,HCC,HCCT,OBC,OBCC>,GBCT extends GroupByClauseTerminal<DTO,HCC,HCCT,OBC,OBCC>,HCC extends HavingConditionClause<DTO,HCC,HCCT,OBC,OBCC>,HCCT extends HavingConditionClauseTerminal<DTO,HCC,HCCT,OBC,OBCC>,OBC extends OrderByClause<DTO,OBC,OBCC>,OBCC extends OrderByClauseChain<DTO,OBC,OBCC>>

Type Parameters:
DTO - the data transfer object (DTO) type representing the result of the query
JC - the type of the JOIN clause used in query construction
JCC - the type of the JOIN condition clause for specifying JOIN conditions
JCCT - the terminal type of the JOIN condition clause
WCC - the type of the WHERE condition clause used for query filtering
WCCT - the terminal type of the WHERE condition clause
GBCT - the terminal type of the GROUP BY clause
HCC - the type of the HAVING condition clause used for filtering grouped data
HCCT - the terminal type of the HAVING condition clause
OBC - the type of the ORDER BY clause defining result sorting
OBCC - the type of the ORDER BY clause chain for chaining multiple sorting expressions
All Superinterfaces:
LimitClauseTerminal<DTO>, OrderByClauseTerminal<DTO>, SelectTerminal<DTO>, WhereClauseTerminal<DTO,GBCT,HCC,HCCT,OBC,OBCC>
All Known Subinterfaces:
FromClauseTerminal<DTO,JC,JCC,JCCT,WCC,WCCT,GBCT,HCC,HCCT,OBC,OBCC>, SqlJoinClauseTerminal
All Known Implementing Classes:
org.litebridgedb.orm.api.select.impl.AbstractFromClauseTerminal, org.litebridgedb.orm.api.select.impl.AbstractJoinClauseTerminal, DtoFromClauseTerminal, DtoJoinConditionClauseTerminal, SqlFromClauseTerminal, SqlJoinConditionClauseTerminal
public interface JoinClauseTerminal<DTO,JC extends JoinClause<DTO,JCC,JCCT>,JCC extends JoinConditionClause<DTO,JCC,JCCT>,JCCT extends JoinConditionClauseTerminal<DTO,JCC,JCCT>,WCC extends WhereConditionClause<DTO,WCC,WCCT,GBCT,HCC,HCCT,OBC,OBCC>,WCCT extends WhereConditionClauseTerminal<DTO,WCC,WCCT,GBCT,HCC,HCCT,OBC,OBCC>,GBCT extends GroupByClauseTerminal<DTO,HCC,HCCT,OBC,OBCC>,HCC extends HavingConditionClause<DTO,HCC,HCCT,OBC,OBCC>,HCCT extends HavingConditionClauseTerminal<DTO,HCC,HCCT,OBC,OBCC>,OBC extends OrderByClause<DTO,OBC,OBCC>,OBCC extends OrderByClauseChain<DTO,OBC,OBCC>> extends WhereClauseTerminal<DTO,GBCT,HCC,HCCT,OBC,OBCC>
Terminal clause in a fluent API for constructing SQL JOIN statements.

This interface extends WhereClauseTerminal to allow specifying WHERE conditions and transitioning to subsequent query stages such as ORDER BY clauses. It also integrates with other clauses like JOIN, JOIN conditions, and WHERE conditions to build complex SQL queries programmatically.

  • Method Details

    • where

      WCC where(String column)
      Starts a WHERE clause for the SQL query.

      Adds a filtering condition to the SQL query based on the specified column. This method is part of a fluent API for building SQL queries and transitions to the next stage where additional filtering conditions can be specified.

      Parameters:
      column - the name of the column to apply the filtering condition on
      Returns:
      an instance of WCC representing the next stage of the where condition clause

    • where

      WCC where(ExpressionSpec expression)