Module litebridge.orm

Package org.litebridgedb.orm.api.select

Interface FromClause<DTO,FCT extends FromClauseTerminal<DTO,JC,JCC,JCCT,WCC,WCCT,GBCT,HCC,HCCT,OBC,OBCC>,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 that represents the result of the query

FCT - the type of the terminal from clause to transition to the next clause or stage

JC - the type of join clause used for specifying table joins

JCC - the type of join condition clause used for providing conditions in joins

JCCT - the terminal type of join condition clause, marking the end of join conditions

WCC - the type of where condition clause used for applying filters

WCCT - the terminal type of where condition clause, marking the end of filter conditions

GBCT - the terminal type of the GROUP BY clause, marking the end of GROUP BY clause

HCC - the type of the HAVING condition clause for further filtering

HCCT - the terminal type of the HAVING condition clause, marking the end of HAVING conditions

OBC - the type of order by clause used to define the ordering of results

OBCC - the type of order by clause chain for chaining multiple orderings

All Known Implementing Classes:

SqlFromClause

public interface FromClause<DTO,FCT extends FromClauseTerminal<DTO,JC,JCC,JCCT,WCC,WCCT,GBCT,HCC,HCCT,OBC,OBCC>,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>>

Starting point for constructing a SQL query by specifying the source table and schema.

This interface is part of a flexible and type-safe fluent API that allows users to construct complex SQL queries in stages.

Method Summary

Modifier and Type	Method	Description
FCT	from(String table)	Specifies the source table and schema for the SQL query, setting the base table and expressions used in the query construction.

Method Details

from

FCT from(String table)

Specifies the source table and schema for the SQL query, setting the base table and expressions used in the query construction.

If the table is not already registered, it is created and associated with an empty schema and given table name.

Parameters:

table - the name of the table within the specified schema

Returns:

an instance of SqlFromClauseTerminal to allow further query configuration