java.lang.Object
- tilda.db.QueryHelper

Direct Known Subclasses:

DeleteQuery, InsertQuery, SelectQuery, UpdateQuery
```
public abstract class QueryHelper
extends java.lang.Object
```
LDH-NOTE This class helps build queries more safely, but it's not a compile-time tool. Therefore, there is no point in trying to catch syntax errors as the database will do that plenty fine.
It's tempting to add extra features to catch mismatched parentheses, checking there is no duplicate table names in the From clause. The only thing that was interesting is that using operators in the SET part of a select or update causes weird things. For example, select a=3 evaluates as a boolean expression which i find weird, so i check for it. Other than that, nothing except major issues like

Author:

ldh

Nested Class Summary

Nested Classes
Modifier and Type	Class	Description
`static class`	`QueryHelper.CaseClause`
`protected static class`	`QueryHelper.CaseWhen`
`protected static class`	`QueryHelper.Op`
`protected static class`	`QueryHelper.S`

Field Summary

Fields
Modifier and Type	Field	Description
`protected Connection`	`_C`
`protected int`	`_Cardinality`
`protected boolean`	`_FullSelect`
`protected boolean`	`_NoWhereClause`
`protected java.lang.StringBuilder`	`_QueryStr`
`protected java.lang.String`	`_SchemaName`
`protected QueryHelper.S`	`_Section`
`protected StatementType`	`_ST`
`protected int`	`_SubSelectCount`
`protected java.lang.String`	`_TableName`
`protected boolean`	`_Where`
`protected int`	`_WherePos`

Constructor Summary

Constructors
Modifier	Constructor	Description
`protected`	`QueryHelper(Connection C, StatementType ST, java.lang.String SchemaName, java.lang.String TableName, boolean FullSelect)`

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`QueryHelper`	`addSuperQueryContext(java.lang.String schemaName, java.lang.String tableName)`
`QueryHelper`	`ageBetween(Type_DatetimePrimitive Col, int[] ageRange)`	Generates a BETWEEN statement based on the age range provided.
`QueryHelper`	`ageEquals(Type_DatetimePrimitive Col, int Age)`
`QueryHelper`	`ageEquals(Type_DatetimePrimitive ColStart, Type_DatetimePrimitive ColEnd, DurationUtil.IntervalEnum Type, int Count)`
`QueryHelper`	`ageGreaterThan(Type_DatetimePrimitive Col, int Age)`
`QueryHelper`	`ageGreaterThan(Type_DatetimePrimitive ColStart, Type_DatetimePrimitive ColEnd, DurationUtil.IntervalEnum Type, int Count)`
`QueryHelper`	`ageGreaterThanOrEqual(Type_DatetimePrimitive Col, int Age)`
`QueryHelper`	`ageGreaterThanOrEqual(Type_DatetimePrimitive ColStart, Type_DatetimePrimitive ColEnd, DurationUtil.IntervalEnum Type, int Count)`
`QueryHelper`	`ageLessThan(Type_DatetimePrimitive Col, int Age)`
`QueryHelper`	`ageLessThan(Type_DatetimePrimitive ColStart, Type_DatetimePrimitive ColEnd, DurationUtil.IntervalEnum Type, int Count)`
`QueryHelper`	`ageLessThanOrEqual(Type_DatetimePrimitive Col, int Age)`
`QueryHelper`	`ageLessThanOrEqual(Type_DatetimePrimitive ColStart, Type_DatetimePrimitive ColEnd, DurationUtil.IntervalEnum Type, int Count)`
`QueryHelper`	`and()`
`QueryHelper`	`any(Type_CharCollection Col, char v)`
`QueryHelper`	`any(Type_CharCollection Col, char[] Vals)`
`QueryHelper`	`any(Type_IntegerCollection Col, int v)`
`QueryHelper`	`any(Type_IntegerCollection Col, int[] Vals)`
`QueryHelper`	`any(Type_StringCollection Col, java.lang.String v)`
`QueryHelper`	`any(Type_StringCollection Col, java.lang.String[] V)`
`QueryHelper`	`any(Type_StringCollection Col, java.util.Collection<java.lang.String> Vals)`
`protected static void`	`array(java.lang.StringBuilder Str, java.lang.String[] V)`
`void`	`clear()`
`QueryHelper`	`closePar()`
`protected QueryHelper`	`colOpBase(ColumnDefinition Col, java.lang.String coalesceValStr, QueryHelper.Op O, java.lang.String ValStr)`
`protected QueryHelper`	`compareBase(ColumnDefinition Col1, ColumnDefinition Col2, QueryHelper.Op O)`
`QueryHelper`	`divide(boolean V)`
`QueryHelper`	`divide(char V)`
`QueryHelper`	`divide(double V)`
`QueryHelper`	`divide(float V)`
`QueryHelper`	`divide(int V)`
`QueryHelper`	`divide(long V)`
`QueryHelper`	`divide(java.lang.String V)`
`QueryHelper`	`divide(ColumnDefinition Col)`
`QueryHelper`	`equals(boolean V)`
`QueryHelper`	`equals(char V)`
`QueryHelper`	`equals(double V)`
`QueryHelper`	`equals(float V)`
`QueryHelper`	`equals(int V)`
`QueryHelper`	`equals(long V)`
`QueryHelper`	`equals(short V)`
`QueryHelper`	`equals(java.lang.String V)`
`QueryHelper`	`equals(java.time.ZonedDateTime ZDT)`
`QueryHelper`	`equals(ColumnDefinition Col1)`
`QueryHelper`	`equals(Type_BooleanPrimitive Col, boolean V)`
`QueryHelper`	`equals(Type_BooleanPrimitive Col, java.lang.Boolean coalesceVal, boolean V)`
`QueryHelper`	`equals(Type_BooleanPrimitive Col1, Type_BooleanPrimitive Col2)`
`QueryHelper`	`equals(Type_CharPrimitive Col, char V)`
`QueryHelper`	`equals(Type_CharPrimitive Col, char coalesceVal, char V)`
`QueryHelper`	`equals(Type_CharPrimitive Col1, Type_CharPrimitive Col2)`
`QueryHelper`	`equals(Type_DatePrimitive Col, java.time.LocalDate LDT)`
`QueryHelper`	`equals(Type_DatePrimitive Col, java.time.LocalDate coalesceVal, java.time.LocalDate V)`
`QueryHelper`	`equals(Type_DatePrimitive Col1, Type_DatePrimitive Col2)`
`QueryHelper`	`equals(Type_DatetimePrimitive Col, java.time.ZonedDateTime ZDT)`
`QueryHelper`	`equals(Type_DatetimePrimitive Col, java.time.ZonedDateTime coalesceVal, java.time.ZonedDateTime V)`
`QueryHelper`	`equals(Type_DatetimePrimitive Col1, Type_DatetimePrimitive Col2)`
`QueryHelper`	`equals(Type_DoublePrimitive Col, double V)`
`QueryHelper`	`equals(Type_DoublePrimitive Col, java.lang.Double coalesceVal, double V)`
`QueryHelper`	`equals(Type_DoublePrimitive Col1, Type_DoublePrimitive Col2)`
`QueryHelper`	`equals(Type_FloatPrimitive Col, float V)`
`QueryHelper`	`equals(Type_FloatPrimitive Col, java.lang.Float coalesceVal, float V)`
`QueryHelper`	`equals(Type_FloatPrimitive Col1, Type_FloatPrimitive Col2)`
`QueryHelper`	`equals(Type_IntegerPrimitive Col, int V)`
`QueryHelper`	`equals(Type_IntegerPrimitive Col, java.lang.Integer coalesceVal, int V)`
`QueryHelper`	`equals(Type_IntegerPrimitive Col1, Type_IntegerPrimitive Col2)`
`QueryHelper`	`equals(Type_IntegerPrimitive Col1, Type_ShortPrimitive Col2)`
`QueryHelper`	`equals(Type_LongPrimitive Col, long V)`
`QueryHelper`	`equals(Type_LongPrimitive Col, java.lang.Long coalesceVal, long V)`
`QueryHelper`	`equals(Type_LongPrimitive Col1, Type_LongPrimitive Col2)`
`QueryHelper`	`equals(Type_LongPrimitive Col1, Type_ShortPrimitive Col2)`
`QueryHelper`	`equals(Type_ShortPrimitive Col, short V)`
`QueryHelper`	`equals(Type_ShortPrimitive Col, java.lang.Short coalesceVal, short V)`
`QueryHelper`	`equals(Type_ShortPrimitive Col1, Type_ShortPrimitive Col2)`
`QueryHelper`	`equals(Type_StringPrimitive Col, java.lang.String V)`
`QueryHelper`	`equals(Type_StringPrimitive Col, java.lang.String coalesceVal, java.lang.String V)`
`QueryHelper`	`equals(Type_StringPrimitive Col1, Type_StringPrimitive Col2)`
`QueryHelper`	`exists(SelectQuery subQ)`
`QueryHelper`	`from()`
`QueryHelper`	`from(java.lang.String SchemaName, java.lang.String TableName)`
`QueryHelper`	`from(SelectQuery Q)`
`protected QueryHelper`	`fromSubSelect(SelectQuery FullSelect)`
`protected QueryHelper`	`fromTable(java.lang.String SchemaName, java.lang.String TableName)`
`int`	`getCardinality()`
`java.util.Iterator<ColumnDefinition>`	`getColumns()`
`java.lang.String`	`getWhereClause()`
`java.lang.String`	`getWhereClause(boolean withWhere)`
`QueryHelper`	`groupBy(QueryHelper.CaseClause clause)`
`QueryHelper`	`groupBy(ColumnDefinition Col)`
`QueryHelper`	`gt(Type_BooleanPrimitive Col, boolean V)`
`QueryHelper`	`gt(Type_BooleanPrimitive Col, java.lang.Boolean coalesceVal, boolean V)`
`QueryHelper`	`gt(Type_BooleanPrimitive Col1, Type_BooleanPrimitive Col2)`
`QueryHelper`	`gt(Type_CharPrimitive Col, char V)`
`QueryHelper`	`gt(Type_CharPrimitive Col, char coalesceVal, char V)`
`QueryHelper`	`gt(Type_CharPrimitive Col1, Type_CharPrimitive Col2)`
`QueryHelper`	`gt(Type_DatePrimitive Col, java.time.LocalDate LDT)`
`QueryHelper`	`gt(Type_DatePrimitive Col, java.time.LocalDate coalesceVal, java.time.LocalDate V)`
`QueryHelper`	`gt(Type_DatePrimitive Col1, Type_DatePrimitive Col2)`
`QueryHelper`	`gt(Type_DatetimePrimitive Col, java.time.LocalDate ZDT)`
`QueryHelper`	`gt(Type_DatetimePrimitive Col, java.time.LocalDate coalesceVal, java.time.LocalDate V)`
`QueryHelper`	`gt(Type_DatetimePrimitive Col, java.time.ZonedDateTime ZDT)`
`QueryHelper`	`gt(Type_DatetimePrimitive Col, java.time.ZonedDateTime coalesceVal, java.time.ZonedDateTime V)`
`QueryHelper`	`gt(Type_DatetimePrimitive Col1, Type_DatetimePrimitive Col2)`
`QueryHelper`	`gt(Type_DoublePrimitive Col, double V)`
`QueryHelper`	`gt(Type_DoublePrimitive Col, java.lang.Double coalesceVal, double V)`
`QueryHelper`	`gt(Type_DoublePrimitive Col1, Type_DoublePrimitive Col2)`
`QueryHelper`	`gt(Type_FloatPrimitive Col, float V)`
`QueryHelper`	`gt(Type_FloatPrimitive Col, java.lang.Float coalesceVal, float V)`
`QueryHelper`	`gt(Type_FloatPrimitive Col1, Type_FloatPrimitive Col2)`
`QueryHelper`	`gt(Type_IntegerPrimitive Col, int V)`
`QueryHelper`	`gt(Type_IntegerPrimitive Col, java.lang.Integer coalesceVal, int V)`
`QueryHelper`	`gt(Type_IntegerPrimitive Col1, Type_IntegerPrimitive Col2)`
`QueryHelper`	`gt(Type_LongPrimitive Col, long V)`
`QueryHelper`	`gt(Type_LongPrimitive Col, java.lang.Long coalesceVal, long V)`
`QueryHelper`	`gt(Type_LongPrimitive Col1, Type_LongPrimitive Col2)`
`QueryHelper`	`gt(Type_ShortPrimitive Col, short V)`
`QueryHelper`	`gt(Type_ShortPrimitive Col, java.lang.Short coalesceVal, short V)`
`QueryHelper`	`gt(Type_ShortPrimitive Col1, Type_ShortPrimitive Col2)`
`QueryHelper`	`gt(Type_StringPrimitive Col, java.lang.String V)`
`QueryHelper`	`gt(Type_StringPrimitive Col, java.lang.String coalesceVal, java.lang.String V)`
`QueryHelper`	`gt(Type_StringPrimitive Col1, Type_StringPrimitive Col2)`
`QueryHelper`	`gte(Type_BooleanPrimitive Col, boolean V)`
`QueryHelper`	`gte(Type_BooleanPrimitive Col, java.lang.Boolean coalesceVal, boolean V)`
`QueryHelper`	`gte(Type_BooleanPrimitive Col1, Type_BooleanPrimitive Col2)`
`QueryHelper`	`gte(Type_CharPrimitive Col, char V)`
`QueryHelper`	`gte(Type_CharPrimitive Col, char coalesceVal, char V)`
`QueryHelper`	`gte(Type_CharPrimitive Col1, Type_CharPrimitive Col2)`
`QueryHelper`	`gte(Type_DatePrimitive Col, java.time.LocalDate LDT)`
`QueryHelper`	`gte(Type_DatePrimitive Col, java.time.LocalDate coalesceVal, java.time.LocalDate V)`
`QueryHelper`	`gte(Type_DatePrimitive Col1, Type_DatePrimitive Col2)`
`QueryHelper`	`gte(Type_DatetimePrimitive Col, java.time.LocalDate ZDT)`
`QueryHelper`	`gte(Type_DatetimePrimitive Col, java.time.LocalDate coalesceVal, java.time.LocalDate V)`
`QueryHelper`	`gte(Type_DatetimePrimitive Col, java.time.ZonedDateTime ZDT)`
`QueryHelper`	`gte(Type_DatetimePrimitive Col, java.time.ZonedDateTime coalesceVal, java.time.ZonedDateTime V)`
`QueryHelper`	`gte(Type_DatetimePrimitive Col1, Type_DatetimePrimitive Col2)`
`QueryHelper`	`gte(Type_DoublePrimitive Col, double V)`
`QueryHelper`	`gte(Type_DoublePrimitive Col, java.lang.Double coalesceVal, double V)`
`QueryHelper`	`gte(Type_DoublePrimitive Col1, Type_DoublePrimitive Col2)`
`QueryHelper`	`gte(Type_FloatPrimitive Col, float V)`
`QueryHelper`	`gte(Type_FloatPrimitive Col, java.lang.Float coalesceVal, float V)`
`QueryHelper`	`gte(Type_FloatPrimitive Col1, Type_FloatPrimitive Col2)`
`QueryHelper`	`gte(Type_IntegerPrimitive Col, int V)`
`QueryHelper`	`gte(Type_IntegerPrimitive Col, java.lang.Integer coalesceVal, int V)`
`QueryHelper`	`gte(Type_IntegerPrimitive Col1, Type_IntegerPrimitive Col2)`
`QueryHelper`	`gte(Type_LongPrimitive Col, long V)`
`QueryHelper`	`gte(Type_LongPrimitive Col, java.lang.Long coalesceVal, long V)`
`QueryHelper`	`gte(Type_LongPrimitive Col1, Type_LongPrimitive Col2)`
`QueryHelper`	`gte(Type_ShortPrimitive Col, short V)`
`QueryHelper`	`gte(Type_ShortPrimitive Col, java.lang.Short coalesceVal, short V)`
`QueryHelper`	`gte(Type_ShortPrimitive Col1, Type_ShortPrimitive Col2)`
`QueryHelper`	`gte(Type_StringPrimitive Col, java.lang.String V)`
`QueryHelper`	`gte(Type_StringPrimitive Col, java.lang.String coalesceVal, java.lang.String V)`
`QueryHelper`	`gte(Type_StringPrimitive Col1, Type_StringPrimitive Col2)`
`QueryHelper`	`in(ColumnDefinition Col, SelectQuery Q)`
`QueryHelper`	`in(ColumnDefinition Col, SelectQuery Q, boolean not)`
`QueryHelper`	`in(Type_CharPrimitive Col, char[] V)`
`QueryHelper`	`in(Type_CharPrimitive Col, char[] V, boolean not)`
`QueryHelper`	`in(Type_CharPrimitive Col, char coalesceVal, char[] V, boolean not)`
`QueryHelper`	`in(Type_DatePrimitive Col, java.time.LocalDate[] V)`
`QueryHelper`	`in(Type_DatePrimitive Col, java.time.LocalDate[] V, boolean not)`
`QueryHelper`	`in(Type_DatePrimitive Col, java.time.LocalDate coalesceVal, java.time.LocalDate[] V, boolean not)`
`QueryHelper`	`in(Type_DatePrimitive Col, java.time.LocalDate coalesceVal, java.util.Collection<java.time.LocalDate> V, boolean not)`
`QueryHelper`	`in(Type_DatePrimitive Col, java.util.Collection<java.time.LocalDate> V)`
`QueryHelper`	`in(Type_DatePrimitive Col, java.util.Collection<java.time.LocalDate> V, boolean not)`
`QueryHelper`	`in(Type_DatetimePrimitive Col, java.time.ZonedDateTime[] V)`
`QueryHelper`	`in(Type_DatetimePrimitive Col, java.time.ZonedDateTime[] V, boolean not)`
`QueryHelper`	`in(Type_DatetimePrimitive Col, java.time.ZonedDateTime coalesceVal, java.time.ZonedDateTime[] V, boolean not)`
`QueryHelper`	`in(Type_DatetimePrimitive Col, java.time.ZonedDateTime coalesceVal, java.util.Collection<java.time.ZonedDateTime> V, boolean not)`
`QueryHelper`	`in(Type_DatetimePrimitive Col, java.util.Collection<java.time.ZonedDateTime> V)`
`QueryHelper`	`in(Type_DatetimePrimitive Col, java.util.Collection<java.time.ZonedDateTime> V, boolean not)`
`QueryHelper`	`in(Type_DoublePrimitive Col, double[] V)`
`QueryHelper`	`in(Type_DoublePrimitive Col, double[] V, boolean not)`
`QueryHelper`	`in(Type_DoublePrimitive Col, java.lang.Double coalesceVal, double[] V, boolean not)`
`QueryHelper`	`in(Type_FloatPrimitive Col, float[] V)`
`QueryHelper`	`in(Type_FloatPrimitive Col, float[] V, boolean not)`
`QueryHelper`	`in(Type_FloatPrimitive Col, java.lang.Float coalesceVal, float[] V, boolean not)`
`QueryHelper`	`in(Type_IntegerPrimitive Col, int[] V)`
`QueryHelper`	`in(Type_IntegerPrimitive Col, int[] V, boolean not)`
`QueryHelper`	`in(Type_IntegerPrimitive Col, java.lang.Integer coalesceVal, int[] V, boolean not)`
`QueryHelper`	`in(Type_LongPrimitive Col, long[] V)`
`QueryHelper`	`in(Type_LongPrimitive Col, long[] V, boolean not)`
`QueryHelper`	`in(Type_LongPrimitive Col, java.lang.Long coalesceVal, long[] V, boolean not)`
`QueryHelper`	`in(Type_ShortPrimitive Col, short[] V)`
`QueryHelper`	`in(Type_ShortPrimitive Col, short[] V, boolean not)`
`QueryHelper`	`in(Type_ShortPrimitive Col, java.lang.Short coalesceVal, short[] V, boolean not)`
`QueryHelper`	`in(Type_StringCollection Col, java.lang.String[] V)`
`QueryHelper`	`in(Type_StringCollection Col, java.lang.String[] V, boolean not)`
`QueryHelper`	`in(Type_StringCollection Col, java.util.Collection<java.lang.String> V)`
`QueryHelper`	`in(Type_StringCollection Col, java.util.Collection<java.lang.String> V, boolean not)`
`QueryHelper`	`in(Type_StringPrimitive Col, java.lang.String[] V)`
`QueryHelper`	`in(Type_StringPrimitive Col, java.lang.String[] V, boolean not)`
`QueryHelper`	`in(Type_StringPrimitive Col, java.lang.String coalesceVal, java.lang.String[] V, boolean not)`
`QueryHelper`	`in(Type_StringPrimitive Col, java.lang.String coalesceVal, java.util.Collection<java.lang.String> V, boolean not)`
`QueryHelper`	`in(Type_StringPrimitive Col, java.util.Collection<java.lang.String> V)`
`QueryHelper`	`in(Type_StringPrimitive Col, java.util.Collection<java.lang.String> V, boolean not)`
`boolean`	`isFullSelectQuery()`
`QueryHelper`	`isNotNull(Nullable Col)`
`QueryHelper`	`isNull(Nullable Col)`
`protected boolean`	`isWhereClause()`	Checks if the query is in a state to accept a where clause.
`boolean`	`isWhereClauseEmpty()`
`QueryHelper`	`like(Type_StringCollection Col, java.lang.String V)`
`QueryHelper`	`like(Type_StringCollection Col, java.lang.String[] V)`
`QueryHelper`	`like(Type_StringCollection Col, java.lang.String[] V, boolean caseInsensitive)`
`QueryHelper`	`like(Type_StringCollection Col, java.lang.String[] V, boolean caseInsensitive, boolean not)`
`QueryHelper`	`like(Type_StringCollection Col, java.lang.String V, boolean caseInsensitive)`
`QueryHelper`	`like(Type_StringCollection Col, java.lang.String V, boolean caseInsensitive, boolean not)`
`QueryHelper`	`like(Type_StringCollection Col, java.util.Collection<java.lang.String> V)`
`QueryHelper`	`like(Type_StringCollection Col, java.util.Collection<java.lang.String> V, boolean caseInsensitive)`
`QueryHelper`	`like(Type_StringCollection Col, java.util.Collection<java.lang.String> V, boolean caseInsensitive, boolean not)`
`QueryHelper`	`like(Type_StringPrimitive[] Cols, java.lang.String V)`
`QueryHelper`	`like(Type_StringPrimitive[] Cols, java.lang.String[] V, boolean or, boolean caseInsensitive)`
`QueryHelper`	`like(Type_StringPrimitive[] Cols, java.lang.String V, boolean caseInsensitive)`
`QueryHelper`	`like(Type_StringPrimitive[] Cols, java.lang.String V, boolean caseInsensitive, boolean not)`
`QueryHelper`	`like(Type_StringPrimitive Col, java.lang.String V)`
`QueryHelper`	`like(Type_StringPrimitive Col, java.lang.String[] V, boolean or, boolean caseInsensitive)`
`QueryHelper`	`like(Type_StringPrimitive Col, java.lang.String V, boolean caseInsensitive)`
`QueryHelper`	`like(Type_StringPrimitive Col, java.lang.String V, boolean caseInsensitive, boolean not)`
`QueryHelper`	`lt(Type_BooleanPrimitive Col, boolean V)`
`QueryHelper`	`lt(Type_BooleanPrimitive Col, java.lang.Boolean coalesceVal, boolean V)`
`QueryHelper`	`lt(Type_BooleanPrimitive Col1, Type_BooleanPrimitive Col2)`
`QueryHelper`	`lt(Type_CharPrimitive Col, char V)`
`QueryHelper`	`lt(Type_CharPrimitive Col, char coalesceVal, char V)`
`QueryHelper`	`lt(Type_CharPrimitive Col1, Type_CharPrimitive Col2)`
`QueryHelper`	`lt(Type_DatePrimitive Col, java.time.LocalDate LDT)`
`QueryHelper`	`lt(Type_DatePrimitive Col, java.time.LocalDate coalesceVal, java.time.LocalDate V)`
`QueryHelper`	`lt(Type_DatePrimitive Col1, Type_DatePrimitive Col2)`
`QueryHelper`	`lt(Type_DatetimePrimitive Col, java.time.LocalDate ZDT)`
`QueryHelper`	`lt(Type_DatetimePrimitive Col, java.time.LocalDate coalesceVal, java.time.LocalDate V)`
`QueryHelper`	`lt(Type_DatetimePrimitive Col, java.time.ZonedDateTime ZDT)`
`QueryHelper`	`lt(Type_DatetimePrimitive Col, java.time.ZonedDateTime coalesceVal, java.time.ZonedDateTime V)`
`QueryHelper`	`lt(Type_DatetimePrimitive Col1, Type_DatetimePrimitive Col2)`
`QueryHelper`	`lt(Type_DoublePrimitive Col, double V)`
`QueryHelper`	`lt(Type_DoublePrimitive Col, java.lang.Double coalesceVal, double V)`
`QueryHelper`	`lt(Type_DoublePrimitive Col1, Type_DoublePrimitive Col2)`
`QueryHelper`	`lt(Type_FloatPrimitive Col, float V)`
`QueryHelper`	`lt(Type_FloatPrimitive Col, java.lang.Float coalesceVal, float V)`
`QueryHelper`	`lt(Type_FloatPrimitive Col1, Type_FloatPrimitive Col2)`
`QueryHelper`	`lt(Type_IntegerPrimitive Col, int V)`
`QueryHelper`	`lt(Type_IntegerPrimitive Col, java.lang.Integer coalesceVal, int V)`
`QueryHelper`	`lt(Type_IntegerPrimitive Col1, Type_IntegerPrimitive Col2)`
`QueryHelper`	`lt(Type_LongPrimitive Col, long V)`
`QueryHelper`	`lt(Type_LongPrimitive Col, java.lang.Long coalesceVal, long V)`
`QueryHelper`	`lt(Type_LongPrimitive Col1, Type_LongPrimitive Col2)`
`QueryHelper`	`lt(Type_ShortPrimitive Col, short V)`
`QueryHelper`	`lt(Type_ShortPrimitive Col, java.lang.Short coalesceVal, short V)`
`QueryHelper`	`lt(Type_ShortPrimitive Col1, Type_IntegerPrimitive Col2)`
`QueryHelper`	`lt(Type_ShortPrimitive Col1, Type_LongPrimitive Col2)`
`QueryHelper`	`lt(Type_ShortPrimitive Col1, Type_ShortPrimitive Col2)`
`QueryHelper`	`lt(Type_StringPrimitive Col, java.lang.String V)`
`QueryHelper`	`lt(Type_StringPrimitive Col, java.lang.String coalesceVal, java.lang.String V)`
`QueryHelper`	`lt(Type_StringPrimitive Col1, Type_StringPrimitive Col2)`
`QueryHelper`	`lte(Type_BooleanPrimitive Col, boolean V)`
`QueryHelper`	`lte(Type_BooleanPrimitive Col, java.lang.Boolean coalesceVal, boolean V)`
`QueryHelper`	`lte(Type_BooleanPrimitive Col1, Type_BooleanPrimitive Col2)`
`QueryHelper`	`lte(Type_CharPrimitive Col, char V)`
`QueryHelper`	`lte(Type_CharPrimitive Col, char coalesceVal, char V)`
`QueryHelper`	`lte(Type_CharPrimitive Col1, Type_CharPrimitive Col2)`
`QueryHelper`	`lte(Type_DatePrimitive Col, java.time.LocalDate LDT)`
`QueryHelper`	`lte(Type_DatePrimitive Col, java.time.LocalDate coalesceVal, java.time.LocalDate V)`
`QueryHelper`	`lte(Type_DatePrimitive Col1, Type_DatePrimitive Col2)`
`QueryHelper`	`lte(Type_DatetimePrimitive Col, java.time.LocalDate ZDT)`
`QueryHelper`	`lte(Type_DatetimePrimitive Col, java.time.LocalDate coalesceVal, java.time.LocalDate V)`
`QueryHelper`	`lte(Type_DatetimePrimitive Col, java.time.ZonedDateTime ZDT)`
`QueryHelper`	`lte(Type_DatetimePrimitive Col, java.time.ZonedDateTime coalesceVal, java.time.ZonedDateTime V)`
`QueryHelper`	`lte(Type_DatetimePrimitive Col1, Type_DatetimePrimitive Col2)`
`QueryHelper`	`lte(Type_DoublePrimitive Col, double V)`
`QueryHelper`	`lte(Type_DoublePrimitive Col, java.lang.Double coalesceVal, double V)`
`QueryHelper`	`lte(Type_DoublePrimitive Col1, Type_DoublePrimitive Col2)`
`QueryHelper`	`lte(Type_FloatPrimitive Col, float V)`
`QueryHelper`	`lte(Type_FloatPrimitive Col, java.lang.Float coalesceVal, float V)`
`QueryHelper`	`lte(Type_FloatPrimitive Col1, Type_FloatPrimitive Col2)`
`QueryHelper`	`lte(Type_IntegerPrimitive Col, int V)`
`QueryHelper`	`lte(Type_IntegerPrimitive Col, java.lang.Integer coalesceVal, int V)`
`QueryHelper`	`lte(Type_IntegerPrimitive Col1, Type_IntegerPrimitive Col2)`
`QueryHelper`	`lte(Type_LongPrimitive Col, long V)`
`QueryHelper`	`lte(Type_LongPrimitive Col, java.lang.Long coalesceVal, long V)`
`QueryHelper`	`lte(Type_LongPrimitive Col1, Type_LongPrimitive Col2)`
`QueryHelper`	`lte(Type_ShortPrimitive Col, short V)`
`QueryHelper`	`lte(Type_ShortPrimitive Col, java.lang.Short coalesceVal, short V)`
`QueryHelper`	`lte(Type_ShortPrimitive Col1, Type_ShortPrimitive Col2)`
`QueryHelper`	`lte(Type_StringPrimitive Col, java.lang.String V)`
`QueryHelper`	`lte(Type_StringPrimitive Col, java.lang.String coalesceVal, java.lang.String V)`
`QueryHelper`	`lte(Type_StringPrimitive Col1, Type_StringPrimitive Col2)`
`QueryHelper`	`minus(boolean V)`
`QueryHelper`	`minus(char V)`
`QueryHelper`	`minus(double V)`
`QueryHelper`	`minus(float V)`
`QueryHelper`	`minus(int V)`
`QueryHelper`	`minus(long V)`
`QueryHelper`	`minus(java.lang.String V)`
`QueryHelper`	`minus(java.time.LocalDate LDT)`
`QueryHelper`	`minus(java.time.ZonedDateTime ZDT)`
`QueryHelper`	`minus(ColumnDefinition Col)`
`QueryHelper`	`multiply(boolean V)`
`QueryHelper`	`multiply(char V)`
`QueryHelper`	`multiply(double V)`
`QueryHelper`	`multiply(float V)`
`QueryHelper`	`multiply(int V)`
`QueryHelper`	`multiply(long V)`
`QueryHelper`	`multiply(java.lang.String V)`
`QueryHelper`	`multiply(ColumnDefinition Col)`
`QueryHelper`	`newLine()`
`QueryHelper`	`newLine(java.lang.String NextHeader)`
`QueryHelper`	`not()`
`QueryHelper`	`notEquals(Type_BooleanPrimitive Col, boolean V)`
`QueryHelper`	`notEquals(Type_BooleanPrimitive Col, java.lang.Boolean coalesceVal, boolean V)`
`QueryHelper`	`notEquals(Type_BooleanPrimitive Col1, Type_BooleanPrimitive Col2)`
`QueryHelper`	`notEquals(Type_CharPrimitive Col, char V)`
`QueryHelper`	`notEquals(Type_CharPrimitive Col, char coalesceVal, char V)`
`QueryHelper`	`notEquals(Type_CharPrimitive Col1, Type_CharPrimitive Col2)`
`QueryHelper`	`notEquals(Type_DatePrimitive Col, java.time.LocalDate LDT)`
`QueryHelper`	`notEquals(Type_DatePrimitive Col, java.time.LocalDate coalesceVal, java.time.LocalDate V)`
`QueryHelper`	`notEquals(Type_DatePrimitive Col1, Type_DatePrimitive Col2)`
`QueryHelper`	`notEquals(Type_DatetimePrimitive Col, java.time.ZonedDateTime ZDT)`
`QueryHelper`	`notEquals(Type_DatetimePrimitive Col, java.time.ZonedDateTime coalesceVal, java.time.ZonedDateTime V)`
`QueryHelper`	`notEquals(Type_DatetimePrimitive Col1, Type_DatetimePrimitive Col2)`
`QueryHelper`	`notEquals(Type_DoublePrimitive Col, double V)`
`QueryHelper`	`notEquals(Type_DoublePrimitive Col, java.lang.Double coalesceVal, double V)`
`QueryHelper`	`notEquals(Type_DoublePrimitive Col1, Type_DoublePrimitive Col2)`
`QueryHelper`	`notEquals(Type_FloatPrimitive Col, float V)`
`QueryHelper`	`notEquals(Type_FloatPrimitive Col, java.lang.Float coalesceVal, float V)`
`QueryHelper`	`notEquals(Type_FloatPrimitive Col1, Type_FloatPrimitive Col2)`
`QueryHelper`	`notEquals(Type_IntegerPrimitive Col, int V)`
`QueryHelper`	`notEquals(Type_IntegerPrimitive Col, java.lang.Integer coalesceVal, int V)`
`QueryHelper`	`notEquals(Type_IntegerPrimitive Col1, Type_IntegerPrimitive Col2)`
`QueryHelper`	`notEquals(Type_LongPrimitive Col, long V)`
`QueryHelper`	`notEquals(Type_LongPrimitive Col, java.lang.Long coalesceVal, long V)`
`QueryHelper`	`notEquals(Type_LongPrimitive Col1, Type_LongPrimitive Col2)`
`QueryHelper`	`notEquals(Type_ShortPrimitive Col, short V)`
`QueryHelper`	`notEquals(Type_ShortPrimitive Col, java.lang.Short coalesceVal, short V)`
`QueryHelper`	`notEquals(Type_ShortPrimitive Col1, Type_ShortPrimitive Col2)`
`QueryHelper`	`notEquals(Type_StringPrimitive Col, java.lang.String V)`
`QueryHelper`	`notEquals(Type_StringPrimitive Col, java.lang.String coalesceVal, java.lang.String V)`
`QueryHelper`	`notEquals(Type_StringPrimitive Col1, Type_StringPrimitive Col2)`
`QueryHelper`	`notExists(SelectQuery subQ)`
`protected void`	`opCol(QueryHelper.Op O, ColumnDefinition Col)`
`QueryHelper`	`openPar()`
`protected static boolean`	`opOK(StatementType st, QueryHelper.S s)`
`protected void`	`opVal(QueryHelper.Op O, boolean V)`
`protected void`	`opVal(QueryHelper.Op O, char V)`
`protected void`	`opVal(QueryHelper.Op O, double V)`
`protected void`	`opVal(QueryHelper.Op O, float V)`
`protected void`	`opVal(QueryHelper.Op O, int V)`
`protected void`	`opVal(QueryHelper.Op O, long V)`
`protected void`	`opVal(QueryHelper.Op O, short V)`
`protected void`	`opVal(QueryHelper.Op O, java.lang.String V)`
`protected void`	`opVal(QueryHelper.Op O, java.time.LocalDate V)`
`protected void`	`opVal(QueryHelper.Op O, java.time.ZonedDateTime V)`
`protected void`	`opValBase(QueryHelper.Op O, java.lang.String ValStr)`
`QueryHelper`	`or()`
`QueryHelper`	`orderBy(ColumnDefinition Col, boolean Asc)`
`QueryHelper`	`orderBy(ColumnDefinition Col, boolean Asc, boolean NullsLast)`
`protected void`	`orderByBase()`
`QueryHelper`	`orderByCountStar(boolean Asc)`
`QueryHelper`	`padding(int spaces)`
`QueryHelper`	`plus(boolean V)`
`QueryHelper`	`plus(char V)`
`QueryHelper`	`plus(double V)`
`QueryHelper`	`plus(float V)`
`QueryHelper`	`plus(int V)`
`QueryHelper`	`plus(long V)`
`QueryHelper`	`plus(java.lang.String V)`
`QueryHelper`	`plus(java.time.LocalDate LDT)`
`QueryHelper`	`plus(java.time.ZonedDateTime ZDT)`
`QueryHelper`	`plus(ColumnDefinition Col)`
`QueryHelper`	`selectCase(QueryHelper.CaseClause clause, java.lang.String elseValue, java.lang.String aliasName)`
`QueryHelper`	`selectColumn(int TableId, java.lang.String ColumnName, AggregateType Agg, java.lang.String AliasName)`
`QueryHelper`	`selectColumn(ColumnDefinition Col)`
`QueryHelper`	`selectColumn(ColumnDefinition Col, AggregateType Agg, java.lang.String Alias)`
`protected QueryHelper`	`selectColumnBase(java.lang.String ColStr)`
`QueryHelper`	`selectCountDistinct(ColumnDefinition Col)`
`QueryHelper`	`selectCountStar()`
`QueryHelper`	`selectDistinctColumn(ColumnDefinition Col)`
`QueryHelper`	`set(Type_BooleanPrimitive Col1, boolean V)`
`QueryHelper`	`set(Type_BooleanPrimitive Col1, Type_BooleanPrimitive Col2)`
`QueryHelper`	`set(Type_CharPrimitive Col1, char V)`
`QueryHelper`	`set(Type_CharPrimitive Col1, Type_CharPrimitive Col2)`
`QueryHelper`	`set(Type_DatetimePrimitive Col1, java.time.ZonedDateTime V)`
`QueryHelper`	`set(Type_DatetimePrimitive Col1, Type_DatetimePrimitive Col2)`
`QueryHelper`	`set(Type_DoublePrimitive Col1, double V)`
`QueryHelper`	`set(Type_DoublePrimitive Col1, Type_DoublePrimitive Col2)`
`QueryHelper`	`set(Type_FloatPrimitive Col1, float V)`
`QueryHelper`	`set(Type_FloatPrimitive Col1, Type_FloatPrimitive Col2)`
`QueryHelper`	`set(Type_IntegerPrimitive Col1, int V)`
`QueryHelper`	`set(Type_IntegerPrimitive Col1, Type_IntegerPrimitive Col2)`
`QueryHelper`	`set(Type_IntegerPrimitive Col1, Type_ShortPrimitive Col2)`
`QueryHelper`	`set(Type_LongPrimitive Col1, long V)`
`QueryHelper`	`set(Type_LongPrimitive Col1, Type_IntegerPrimitive Col2)`
`QueryHelper`	`set(Type_LongPrimitive Col1, Type_LongPrimitive Col2)`
`QueryHelper`	`set(Type_LongPrimitive Col1, Type_ShortPrimitive Col2)`
`QueryHelper`	`set(Type_ShortPrimitive Col1, short V)`
`QueryHelper`	`set(Type_ShortPrimitive Col1, Type_ShortPrimitive Col2)`
`QueryHelper`	`set(Type_StringPrimitive Col1, java.lang.String V)`
`QueryHelper`	`set(Type_StringPrimitive Col1, Type_StringPrimitive Col2)`
`protected void`	`setColumn(ColumnDefinition Col)`
`QueryHelper`	`setNow(Type_DatetimePrimitive Col1)`
`QueryHelper`	`subWhere(java.lang.String subWhereClause)`	Validates the subWhereClause against the TildaSQL parser and if it passes, adds it to the current query object, in parenthesis as to be cohesive with the rest of the query.
`QueryHelper`	`subWhere(QueryHelper.CaseClause clause)`
`QueryHelper`	`subWhere(SelectQuery subWhere)`
`QueryHelper`	`tableSample(float Percentage, boolean Repeatable)`
`java.lang.String`	`toString()`
`QueryHelper`	`values()`
`protected void`	`valuesBase()`
`QueryHelper`	`where()`
`QueryHelper`	`within(Type_DatetimePrimitive Col, Type_DatetimePrimitive ColStart, long durationCount, DurationUtil.IntervalEnum Type)`	If Duration is positive, implements the condition Col >= ColStart && Col < ColStart + interval specified. If Duration is negative, implements the condition Col > ColStart - interval specified && Col <= ColStart (with the interval negated).

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

_SchemaName

protected final java.lang.String _SchemaName

_TableName

protected final java.lang.String _TableName

_ST
```
protected final StatementType _ST
```

_FullSelect
```
protected boolean _FullSelect
```

_C
```
protected Connection _C
```

_QueryStr

protected java.lang.StringBuilder _QueryStr

_Section
```
protected QueryHelper.S _Section
```

_Where
```
protected boolean _Where
```

_NoWhereClause
```
protected boolean _NoWhereClause
```

_WherePos
```
protected int _WherePos
```

_Cardinality
```
protected int _Cardinality
```

_SubSelectCount
```
protected int _SubSelectCount
```

Constructor Detail

QueryHelper

protected QueryHelper(Connection C,
                      StatementType ST,
                      java.lang.String SchemaName,
                      java.lang.String TableName,
                      boolean FullSelect)
               throws java.lang.Exception

Throws:: java.lang.Exception

Method Detail

isFullSelectQuery
```
public boolean isFullSelectQuery()
```

clear

public void clear()
           throws java.lang.Exception

Throws:: java.lang.Exception

isWhereClauseEmpty
```
public boolean isWhereClauseEmpty()
```

getCardinality
```
public int getCardinality()
```

getColumns

public java.util.Iterator<ColumnDefinition> getColumns()

valuesBase

protected final void valuesBase()
                         throws java.lang.Exception

Throws:: java.lang.Exception

selectColumnBase

protected final QueryHelper selectColumnBase(java.lang.String ColStr)
                                      throws java.lang.Exception

Throws:: java.lang.Exception

selectColumn

public final QueryHelper selectColumn(ColumnDefinition Col)
                               throws java.lang.Exception

Throws:: java.lang.Exception

selectDistinctColumn

public final QueryHelper selectDistinctColumn(ColumnDefinition Col)
                                       throws java.lang.Exception

Throws:: java.lang.Exception

selectCountStar

public final QueryHelper selectCountStar()
                                  throws java.lang.Exception

Throws:: java.lang.Exception

selectCountDistinct

public final QueryHelper selectCountDistinct(ColumnDefinition Col)
                                      throws java.lang.Exception

Throws:: java.lang.Exception

selectColumn

public final QueryHelper selectColumn(ColumnDefinition Col,
                                      AggregateType Agg,
                                      java.lang.String Alias)
                               throws java.lang.Exception

Throws:: java.lang.Exception

selectColumn

public final QueryHelper selectColumn(int TableId,
                                      java.lang.String ColumnName,
                                      AggregateType Agg,
                                      java.lang.String AliasName)
                               throws java.lang.Exception

Throws:: java.lang.Exception

selectCase

public QueryHelper selectCase(QueryHelper.CaseClause clause,
                              java.lang.String elseValue,
                              java.lang.String aliasName)
                       throws java.lang.Exception

Throws:: java.lang.Exception

fromTable

protected final QueryHelper fromTable(java.lang.String SchemaName,
                                      java.lang.String TableName)
                               throws java.lang.Exception

Throws:: java.lang.Exception

fromSubSelect

protected final QueryHelper fromSubSelect(SelectQuery FullSelect)
                                   throws java.lang.Exception

Throws:: java.lang.Exception

where

public final QueryHelper where()
                        throws java.lang.Exception

Throws:: java.lang.Exception

subWhere

public QueryHelper subWhere(SelectQuery subWhere)
                     throws java.lang.Exception

Throws:: java.lang.Exception

subWhere

public QueryHelper subWhere(QueryHelper.CaseClause clause)
                     throws java.lang.Exception

Throws:: java.lang.Exception

subWhere
```
public QueryHelper subWhere(java.lang.String subWhereClause)
                     throws java.lang.Exception
```
Validates the subWhereClause against the TildaSQL parser and if it passes, adds it to the current query object, in parenthesis as to be cohesive with the rest of the query.

Parameters:

subWhereClause -

Returns:

Throws:

java.lang.Exception

and

public final QueryHelper and()
                      throws java.lang.Exception

Throws:: java.lang.Exception

or

public final QueryHelper or()
                     throws java.lang.Exception

Throws:: java.lang.Exception

not

public final QueryHelper not()
                      throws java.lang.Exception

Throws:: java.lang.Exception

openPar

public final QueryHelper openPar()
                          throws java.lang.Exception

Throws:: java.lang.Exception

closePar

public final QueryHelper closePar()
                           throws java.lang.Exception

Throws:: java.lang.Exception

opCol

protected final void opCol(QueryHelper.Op O,
                           ColumnDefinition Col)
                    throws java.lang.Exception

Throws:: java.lang.Exception

opOK

protected static boolean opOK(StatementType st,
                              QueryHelper.S s)

opValBase

protected final void opValBase(QueryHelper.Op O,
                               java.lang.String ValStr)
                        throws java.lang.Exception

Throws:: java.lang.Exception

opVal

protected final void opVal(QueryHelper.Op O,
                           java.lang.String V)
                    throws java.lang.Exception

Throws:: java.lang.Exception

opVal

protected final void opVal(QueryHelper.Op O,
                           boolean V)
                    throws java.lang.Exception

Throws:: java.lang.Exception

opVal

protected final void opVal(QueryHelper.Op O,
                           double V)
                    throws java.lang.Exception

Throws:: java.lang.Exception

opVal

protected final void opVal(QueryHelper.Op O,
                           float V)
                    throws java.lang.Exception

Throws:: java.lang.Exception

opVal

protected final void opVal(QueryHelper.Op O,
                           short V)
                    throws java.lang.Exception

Throws:: java.lang.Exception

opVal

protected final void opVal(QueryHelper.Op O,
                           int V)
                    throws java.lang.Exception

Throws:: java.lang.Exception

opVal

protected final void opVal(QueryHelper.Op O,
                           long V)
                    throws java.lang.Exception

Throws:: java.lang.Exception

opVal

protected final void opVal(QueryHelper.Op O,
                           char V)
                    throws java.lang.Exception

Throws:: java.lang.Exception

opVal

protected final void opVal(QueryHelper.Op O,
                           java.time.ZonedDateTime V)
                    throws java.lang.Exception

Throws:: java.lang.Exception

opVal

protected final void opVal(QueryHelper.Op O,
                           java.time.LocalDate V)
                    throws java.lang.Exception

Throws:: java.lang.Exception

getWhereClause

public java.lang.String getWhereClause()
                                throws java.lang.Exception

Throws:: java.lang.Exception

getWhereClause

public java.lang.String getWhereClause(boolean withWhere)
                                throws java.lang.Exception

Throws:: java.lang.Exception

values

public QueryHelper values()
                   throws java.lang.Exception

Throws:: java.lang.Exception

from

public QueryHelper from()
                 throws java.lang.Exception

Throws:: java.lang.Exception

from

public QueryHelper from(java.lang.String SchemaName,
                        java.lang.String TableName)
                 throws java.lang.Exception

Throws:: java.lang.Exception

tableSample

public QueryHelper tableSample(float Percentage,
                               boolean Repeatable)
                        throws java.lang.Exception

Throws:: java.lang.Exception

from

public QueryHelper from(SelectQuery Q)
                 throws java.lang.Exception

Throws:: java.lang.Exception

setColumn

protected final void setColumn(ColumnDefinition Col)
                        throws java.lang.Exception

Throws:: java.lang.Exception

set

public QueryHelper set(Type_StringPrimitive Col1,
                       Type_StringPrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

set

public QueryHelper set(Type_CharPrimitive Col1,
                       Type_CharPrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

set

public QueryHelper set(Type_BooleanPrimitive Col1,
                       Type_BooleanPrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

set

public QueryHelper set(Type_ShortPrimitive Col1,
                       Type_ShortPrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

set

public QueryHelper set(Type_IntegerPrimitive Col1,
                       Type_ShortPrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

set

public QueryHelper set(Type_LongPrimitive Col1,
                       Type_ShortPrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

set

public QueryHelper set(Type_IntegerPrimitive Col1,
                       Type_IntegerPrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

set

public QueryHelper set(Type_LongPrimitive Col1,
                       Type_IntegerPrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

set

public QueryHelper set(Type_LongPrimitive Col1,
                       Type_LongPrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

set

public QueryHelper set(Type_FloatPrimitive Col1,
                       Type_FloatPrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

set

public QueryHelper set(Type_DoublePrimitive Col1,
                       Type_DoublePrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

set

public QueryHelper set(Type_DatetimePrimitive Col1,
                       Type_DatetimePrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

set

public QueryHelper set(Type_StringPrimitive Col1,
                       java.lang.String V)
                throws java.lang.Exception

Throws:: java.lang.Exception

set

public QueryHelper set(Type_CharPrimitive Col1,
                       char V)
                throws java.lang.Exception

Throws:: java.lang.Exception

set

public QueryHelper set(Type_BooleanPrimitive Col1,
                       boolean V)
                throws java.lang.Exception

Throws:: java.lang.Exception

set

public QueryHelper set(Type_ShortPrimitive Col1,
                       short V)
                throws java.lang.Exception

Throws:: java.lang.Exception

set

public QueryHelper set(Type_IntegerPrimitive Col1,
                       int V)
                throws java.lang.Exception

Throws:: java.lang.Exception

set

public QueryHelper set(Type_LongPrimitive Col1,
                       long V)
                throws java.lang.Exception

Throws:: java.lang.Exception

set

public QueryHelper set(Type_FloatPrimitive Col1,
                       float V)
                throws java.lang.Exception

Throws:: java.lang.Exception

set

public QueryHelper set(Type_DoublePrimitive Col1,
                       double V)
                throws java.lang.Exception

Throws:: java.lang.Exception

set

public QueryHelper set(Type_DatetimePrimitive Col1,
                       java.time.ZonedDateTime V)
                throws java.lang.Exception

Throws:: java.lang.Exception

setNow

public QueryHelper setNow(Type_DatetimePrimitive Col1)
                   throws java.lang.Exception

Throws:: java.lang.Exception

isWhereClause
```
protected boolean isWhereClause()
```
Checks if the query is in a state to accept a where clause. If the query is in FROM state, it will switch to WHERE state automatically.

Returns:

in

public QueryHelper in(Type_StringPrimitive Col,
                      java.lang.String[] V)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_StringPrimitive Col,
                      java.lang.String[] V,
                      boolean not)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_StringPrimitive Col,
                      java.lang.String coalesceVal,
                      java.lang.String[] V,
                      boolean not)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_StringPrimitive Col,
                      java.util.Collection<java.lang.String> V)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_StringPrimitive Col,
                      java.util.Collection<java.lang.String> V,
                      boolean not)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_StringPrimitive Col,
                      java.lang.String coalesceVal,
                      java.util.Collection<java.lang.String> V,
                      boolean not)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_StringCollection Col,
                      java.lang.String[] V)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_StringCollection Col,
                      java.lang.String[] V,
                      boolean not)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_StringCollection Col,
                      java.util.Collection<java.lang.String> V)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_StringCollection Col,
                      java.util.Collection<java.lang.String> V,
                      boolean not)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_CharPrimitive Col,
                      char[] V)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_CharPrimitive Col,
                      char[] V,
                      boolean not)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_CharPrimitive Col,
                      char coalesceVal,
                      char[] V,
                      boolean not)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_ShortPrimitive Col,
                      short[] V)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_ShortPrimitive Col,
                      short[] V,
                      boolean not)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_ShortPrimitive Col,
                      java.lang.Short coalesceVal,
                      short[] V,
                      boolean not)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_IntegerPrimitive Col,
                      int[] V)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_IntegerPrimitive Col,
                      int[] V,
                      boolean not)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_IntegerPrimitive Col,
                      java.lang.Integer coalesceVal,
                      int[] V,
                      boolean not)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_LongPrimitive Col,
                      long[] V)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_LongPrimitive Col,
                      long[] V,
                      boolean not)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_LongPrimitive Col,
                      java.lang.Long coalesceVal,
                      long[] V,
                      boolean not)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_FloatPrimitive Col,
                      float[] V)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_FloatPrimitive Col,
                      float[] V,
                      boolean not)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_FloatPrimitive Col,
                      java.lang.Float coalesceVal,
                      float[] V,
                      boolean not)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_DoublePrimitive Col,
                      double[] V)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_DoublePrimitive Col,
                      double[] V,
                      boolean not)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_DoublePrimitive Col,
                      java.lang.Double coalesceVal,
                      double[] V,
                      boolean not)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_DatetimePrimitive Col,
                      java.time.ZonedDateTime[] V)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_DatetimePrimitive Col,
                      java.time.ZonedDateTime[] V,
                      boolean not)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_DatetimePrimitive Col,
                      java.time.ZonedDateTime coalesceVal,
                      java.time.ZonedDateTime[] V,
                      boolean not)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_DatePrimitive Col,
                      java.util.Collection<java.time.LocalDate> V)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_DatePrimitive Col,
                      java.util.Collection<java.time.LocalDate> V,
                      boolean not)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_DatePrimitive Col,
                      java.time.LocalDate coalesceVal,
                      java.util.Collection<java.time.LocalDate> V,
                      boolean not)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_DatePrimitive Col,
                      java.time.LocalDate[] V)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_DatePrimitive Col,
                      java.time.LocalDate[] V,
                      boolean not)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_DatePrimitive Col,
                      java.time.LocalDate coalesceVal,
                      java.time.LocalDate[] V,
                      boolean not)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_DatetimePrimitive Col,
                      java.util.Collection<java.time.ZonedDateTime> V)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_DatetimePrimitive Col,
                      java.util.Collection<java.time.ZonedDateTime> V,
                      boolean not)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(Type_DatetimePrimitive Col,
                      java.time.ZonedDateTime coalesceVal,
                      java.util.Collection<java.time.ZonedDateTime> V,
                      boolean not)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(ColumnDefinition Col,
                      SelectQuery Q)
               throws java.lang.Exception

Throws:: java.lang.Exception

in

public QueryHelper in(ColumnDefinition Col,
                      SelectQuery Q,
                      boolean not)
               throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(java.lang.String V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(char V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(boolean V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(short V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(int V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(long V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(float V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(double V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(java.time.ZonedDateTime ZDT)
                   throws java.lang.Exception

Throws:: java.lang.Exception

compareBase

protected QueryHelper compareBase(ColumnDefinition Col1,
                                  ColumnDefinition Col2,
                                  QueryHelper.Op O)
                           throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(ColumnDefinition Col1)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_StringPrimitive Col1,
                          Type_StringPrimitive Col2)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_DatetimePrimitive Col1,
                          Type_DatetimePrimitive Col2)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_DatePrimitive Col1,
                          Type_DatePrimitive Col2)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_CharPrimitive Col1,
                          Type_CharPrimitive Col2)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_BooleanPrimitive Col1,
                          Type_BooleanPrimitive Col2)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_ShortPrimitive Col1,
                          Type_ShortPrimitive Col2)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_IntegerPrimitive Col1,
                          Type_ShortPrimitive Col2)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_LongPrimitive Col1,
                          Type_ShortPrimitive Col2)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_IntegerPrimitive Col1,
                          Type_IntegerPrimitive Col2)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_LongPrimitive Col1,
                          Type_LongPrimitive Col2)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_FloatPrimitive Col1,
                          Type_FloatPrimitive Col2)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_DoublePrimitive Col1,
                          Type_DoublePrimitive Col2)
                   throws java.lang.Exception

Throws:: java.lang.Exception

colOpBase

protected QueryHelper colOpBase(ColumnDefinition Col,
                                java.lang.String coalesceValStr,
                                QueryHelper.Op O,
                                java.lang.String ValStr)
                         throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_StringPrimitive Col,
                          java.lang.String coalesceVal,
                          java.lang.String V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_StringPrimitive Col,
                          java.lang.String V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_CharPrimitive Col,
                          char coalesceVal,
                          char V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_CharPrimitive Col,
                          char V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_BooleanPrimitive Col,
                          java.lang.Boolean coalesceVal,
                          boolean V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_BooleanPrimitive Col,
                          boolean V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_ShortPrimitive Col,
                          java.lang.Short coalesceVal,
                          short V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_ShortPrimitive Col,
                          short V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_IntegerPrimitive Col,
                          java.lang.Integer coalesceVal,
                          int V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_IntegerPrimitive Col,
                          int V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_LongPrimitive Col,
                          java.lang.Long coalesceVal,
                          long V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_LongPrimitive Col,
                          long V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_FloatPrimitive Col,
                          java.lang.Float coalesceVal,
                          float V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_FloatPrimitive Col,
                          float V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_DoublePrimitive Col,
                          java.lang.Double coalesceVal,
                          double V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_DoublePrimitive Col,
                          double V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_DatetimePrimitive Col,
                          java.time.ZonedDateTime coalesceVal,
                          java.time.ZonedDateTime V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_DatetimePrimitive Col,
                          java.time.ZonedDateTime ZDT)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_DatePrimitive Col,
                          java.time.LocalDate coalesceVal,
                          java.time.LocalDate V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

equals

public QueryHelper equals(Type_DatePrimitive Col,
                          java.time.LocalDate LDT)
                   throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_StringPrimitive Col,
                      java.lang.String coalesceVal,
                      java.lang.String V)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_StringPrimitive Col,
                      java.lang.String V)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_CharPrimitive Col,
                      char coalesceVal,
                      char V)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_CharPrimitive Col,
                      char V)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_BooleanPrimitive Col,
                      java.lang.Boolean coalesceVal,
                      boolean V)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_BooleanPrimitive Col,
                      boolean V)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_ShortPrimitive Col,
                      java.lang.Short coalesceVal,
                      short V)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_ShortPrimitive Col,
                      short V)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_IntegerPrimitive Col,
                      java.lang.Integer coalesceVal,
                      int V)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_IntegerPrimitive Col,
                      int V)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_LongPrimitive Col,
                      java.lang.Long coalesceVal,
                      long V)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_LongPrimitive Col,
                      long V)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_FloatPrimitive Col,
                      java.lang.Float coalesceVal,
                      float V)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_FloatPrimitive Col,
                      float V)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_DoublePrimitive Col,
                      java.lang.Double coalesceVal,
                      double V)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_DoublePrimitive Col,
                      double V)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_DatetimePrimitive Col,
                      java.time.ZonedDateTime coalesceVal,
                      java.time.ZonedDateTime V)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_DatetimePrimitive Col,
                      java.time.ZonedDateTime ZDT)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_DatetimePrimitive Col,
                      java.time.LocalDate coalesceVal,
                      java.time.LocalDate V)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_DatetimePrimitive Col,
                      java.time.LocalDate ZDT)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_DatePrimitive Col,
                      java.time.LocalDate coalesceVal,
                      java.time.LocalDate V)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_DatePrimitive Col,
                      java.time.LocalDate LDT)
               throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_StringPrimitive Col,
                       java.lang.String coalesceVal,
                       java.lang.String V)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_StringPrimitive Col,
                       java.lang.String V)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_CharPrimitive Col,
                       char coalesceVal,
                       char V)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_CharPrimitive Col,
                       char V)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_BooleanPrimitive Col,
                       java.lang.Boolean coalesceVal,
                       boolean V)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_BooleanPrimitive Col,
                       boolean V)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_ShortPrimitive Col,
                       java.lang.Short coalesceVal,
                       short V)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_ShortPrimitive Col,
                       short V)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_IntegerPrimitive Col,
                       java.lang.Integer coalesceVal,
                       int V)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_IntegerPrimitive Col,
                       int V)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_LongPrimitive Col,
                       java.lang.Long coalesceVal,
                       long V)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_LongPrimitive Col,
                       long V)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_FloatPrimitive Col,
                       java.lang.Float coalesceVal,
                       float V)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_FloatPrimitive Col,
                       float V)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_DoublePrimitive Col,
                       java.lang.Double coalesceVal,
                       double V)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_DoublePrimitive Col,
                       double V)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_DatetimePrimitive Col,
                       java.time.ZonedDateTime coalesceVal,
                       java.time.ZonedDateTime V)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_DatetimePrimitive Col,
                       java.time.ZonedDateTime ZDT)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_DatetimePrimitive Col,
                       java.time.LocalDate coalesceVal,
                       java.time.LocalDate V)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_DatetimePrimitive Col,
                       java.time.LocalDate ZDT)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_DatePrimitive Col,
                       java.time.LocalDate coalesceVal,
                       java.time.LocalDate V)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_DatePrimitive Col,
                       java.time.LocalDate LDT)
                throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_StringPrimitive Col,
                      java.lang.String coalesceVal,
                      java.lang.String V)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_StringPrimitive Col,
                      java.lang.String V)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_CharPrimitive Col,
                      char coalesceVal,
                      char V)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_CharPrimitive Col,
                      char V)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_BooleanPrimitive Col,
                      java.lang.Boolean coalesceVal,
                      boolean V)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_BooleanPrimitive Col,
                      boolean V)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_ShortPrimitive Col,
                      java.lang.Short coalesceVal,
                      short V)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_ShortPrimitive Col,
                      short V)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_IntegerPrimitive Col,
                      java.lang.Integer coalesceVal,
                      int V)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_IntegerPrimitive Col,
                      int V)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_LongPrimitive Col,
                      java.lang.Long coalesceVal,
                      long V)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_LongPrimitive Col,
                      long V)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_FloatPrimitive Col,
                      java.lang.Float coalesceVal,
                      float V)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_FloatPrimitive Col,
                      float V)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_DoublePrimitive Col,
                      java.lang.Double coalesceVal,
                      double V)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_DoublePrimitive Col,
                      double V)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_DatetimePrimitive Col,
                      java.time.ZonedDateTime coalesceVal,
                      java.time.ZonedDateTime V)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_DatetimePrimitive Col,
                      java.time.ZonedDateTime ZDT)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_DatetimePrimitive Col,
                      java.time.LocalDate coalesceVal,
                      java.time.LocalDate V)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_DatetimePrimitive Col,
                      java.time.LocalDate ZDT)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_DatePrimitive Col,
                      java.time.LocalDate coalesceVal,
                      java.time.LocalDate V)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_DatePrimitive Col,
                      java.time.LocalDate LDT)
               throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_StringPrimitive Col,
                       java.lang.String coalesceVal,
                       java.lang.String V)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_StringPrimitive Col,
                       java.lang.String V)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_CharPrimitive Col,
                       char coalesceVal,
                       char V)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_CharPrimitive Col,
                       char V)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_BooleanPrimitive Col,
                       java.lang.Boolean coalesceVal,
                       boolean V)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_BooleanPrimitive Col,
                       boolean V)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_ShortPrimitive Col,
                       java.lang.Short coalesceVal,
                       short V)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_ShortPrimitive Col,
                       short V)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_IntegerPrimitive Col,
                       java.lang.Integer coalesceVal,
                       int V)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_IntegerPrimitive Col,
                       int V)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_LongPrimitive Col,
                       java.lang.Long coalesceVal,
                       long V)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_LongPrimitive Col,
                       long V)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_FloatPrimitive Col,
                       java.lang.Float coalesceVal,
                       float V)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_FloatPrimitive Col,
                       float V)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_DoublePrimitive Col,
                       java.lang.Double coalesceVal,
                       double V)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_DoublePrimitive Col,
                       double V)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_DatetimePrimitive Col,
                       java.time.ZonedDateTime coalesceVal,
                       java.time.ZonedDateTime V)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_DatetimePrimitive Col,
                       java.time.ZonedDateTime ZDT)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_DatetimePrimitive Col,
                       java.time.LocalDate coalesceVal,
                       java.time.LocalDate V)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_DatetimePrimitive Col,
                       java.time.LocalDate ZDT)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_DatePrimitive Col,
                       java.time.LocalDate coalesceVal,
                       java.time.LocalDate V)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_DatePrimitive Col,
                       java.time.LocalDate LDT)
                throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_StringPrimitive Col,
                             java.lang.String coalesceVal,
                             java.lang.String V)
                      throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_StringPrimitive Col,
                             java.lang.String V)
                      throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_CharPrimitive Col,
                             char coalesceVal,
                             char V)
                      throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_CharPrimitive Col,
                             char V)
                      throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_BooleanPrimitive Col,
                             java.lang.Boolean coalesceVal,
                             boolean V)
                      throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_BooleanPrimitive Col,
                             boolean V)
                      throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_ShortPrimitive Col,
                             java.lang.Short coalesceVal,
                             short V)
                      throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_ShortPrimitive Col,
                             short V)
                      throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_IntegerPrimitive Col,
                             java.lang.Integer coalesceVal,
                             int V)
                      throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_IntegerPrimitive Col,
                             int V)
                      throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_LongPrimitive Col,
                             java.lang.Long coalesceVal,
                             long V)
                      throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_LongPrimitive Col,
                             long V)
                      throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_FloatPrimitive Col,
                             java.lang.Float coalesceVal,
                             float V)
                      throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_FloatPrimitive Col,
                             float V)
                      throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_DoublePrimitive Col,
                             java.lang.Double coalesceVal,
                             double V)
                      throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_DoublePrimitive Col,
                             double V)
                      throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_DatetimePrimitive Col,
                             java.time.ZonedDateTime coalesceVal,
                             java.time.ZonedDateTime V)
                      throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_DatetimePrimitive Col,
                             java.time.ZonedDateTime ZDT)
                      throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_DatePrimitive Col,
                             java.time.LocalDate coalesceVal,
                             java.time.LocalDate V)
                      throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_DatePrimitive Col,
                             java.time.LocalDate LDT)
                      throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_StringPrimitive Col1,
                      Type_StringPrimitive Col2)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_DatetimePrimitive Col1,
                      Type_DatetimePrimitive Col2)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_DatePrimitive Col1,
                      Type_DatePrimitive Col2)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_CharPrimitive Col1,
                      Type_CharPrimitive Col2)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_BooleanPrimitive Col1,
                      Type_BooleanPrimitive Col2)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_ShortPrimitive Col1,
                      Type_ShortPrimitive Col2)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_ShortPrimitive Col1,
                      Type_IntegerPrimitive Col2)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_ShortPrimitive Col1,
                      Type_LongPrimitive Col2)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_IntegerPrimitive Col1,
                      Type_IntegerPrimitive Col2)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_LongPrimitive Col1,
                      Type_LongPrimitive Col2)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_FloatPrimitive Col1,
                      Type_FloatPrimitive Col2)
               throws java.lang.Exception

Throws:: java.lang.Exception

lt

public QueryHelper lt(Type_DoublePrimitive Col1,
                      Type_DoublePrimitive Col2)
               throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_StringPrimitive Col1,
                       Type_StringPrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_DatetimePrimitive Col1,
                       Type_DatetimePrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_DatePrimitive Col1,
                       Type_DatePrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_CharPrimitive Col1,
                       Type_CharPrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_BooleanPrimitive Col1,
                       Type_BooleanPrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_ShortPrimitive Col1,
                       Type_ShortPrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_IntegerPrimitive Col1,
                       Type_IntegerPrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_LongPrimitive Col1,
                       Type_LongPrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_FloatPrimitive Col1,
                       Type_FloatPrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

lte

public QueryHelper lte(Type_DoublePrimitive Col1,
                       Type_DoublePrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_StringPrimitive Col1,
                      Type_StringPrimitive Col2)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_DatetimePrimitive Col1,
                      Type_DatetimePrimitive Col2)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_DatePrimitive Col1,
                      Type_DatePrimitive Col2)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_CharPrimitive Col1,
                      Type_CharPrimitive Col2)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_BooleanPrimitive Col1,
                      Type_BooleanPrimitive Col2)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_ShortPrimitive Col1,
                      Type_ShortPrimitive Col2)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_IntegerPrimitive Col1,
                      Type_IntegerPrimitive Col2)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_LongPrimitive Col1,
                      Type_LongPrimitive Col2)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_FloatPrimitive Col1,
                      Type_FloatPrimitive Col2)
               throws java.lang.Exception

Throws:: java.lang.Exception

gt

public QueryHelper gt(Type_DoublePrimitive Col1,
                      Type_DoublePrimitive Col2)
               throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_StringPrimitive Col1,
                       Type_StringPrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_DatetimePrimitive Col1,
                       Type_DatetimePrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_DatePrimitive Col1,
                       Type_DatePrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_CharPrimitive Col1,
                       Type_CharPrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_BooleanPrimitive Col1,
                       Type_BooleanPrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_ShortPrimitive Col1,
                       Type_ShortPrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_IntegerPrimitive Col1,
                       Type_IntegerPrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_LongPrimitive Col1,
                       Type_LongPrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_FloatPrimitive Col1,
                       Type_FloatPrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

gte

public QueryHelper gte(Type_DoublePrimitive Col1,
                       Type_DoublePrimitive Col2)
                throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_StringPrimitive Col1,
                             Type_StringPrimitive Col2)
                      throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_DatetimePrimitive Col1,
                             Type_DatetimePrimitive Col2)
                      throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_DatePrimitive Col1,
                             Type_DatePrimitive Col2)
                      throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_CharPrimitive Col1,
                             Type_CharPrimitive Col2)
                      throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_BooleanPrimitive Col1,
                             Type_BooleanPrimitive Col2)
                      throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_ShortPrimitive Col1,
                             Type_ShortPrimitive Col2)
                      throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_IntegerPrimitive Col1,
                             Type_IntegerPrimitive Col2)
                      throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_LongPrimitive Col1,
                             Type_LongPrimitive Col2)
                      throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_FloatPrimitive Col1,
                             Type_FloatPrimitive Col2)
                      throws java.lang.Exception

Throws:: java.lang.Exception

notEquals

public QueryHelper notEquals(Type_DoublePrimitive Col1,
                             Type_DoublePrimitive Col2)
                      throws java.lang.Exception

Throws:: java.lang.Exception

plus

public QueryHelper plus(ColumnDefinition Col)
                 throws java.lang.Exception

Throws:: java.lang.Exception

plus

public QueryHelper plus(java.lang.String V)
                 throws java.lang.Exception

Throws:: java.lang.Exception

plus

public QueryHelper plus(char V)
                 throws java.lang.Exception

Throws:: java.lang.Exception

plus

public QueryHelper plus(boolean V)
                 throws java.lang.Exception

Throws:: java.lang.Exception

plus

public QueryHelper plus(int V)
                 throws java.lang.Exception

Throws:: java.lang.Exception

plus

public QueryHelper plus(long V)
                 throws java.lang.Exception

Throws:: java.lang.Exception

plus

public QueryHelper plus(float V)
                 throws java.lang.Exception

Throws:: java.lang.Exception

plus

public QueryHelper plus(double V)
                 throws java.lang.Exception

Throws:: java.lang.Exception

plus

public QueryHelper plus(java.time.ZonedDateTime ZDT)
                 throws java.lang.Exception

Throws:: java.lang.Exception

plus

public QueryHelper plus(java.time.LocalDate LDT)
                 throws java.lang.Exception

Throws:: java.lang.Exception

minus

public QueryHelper minus(ColumnDefinition Col)
                  throws java.lang.Exception

Throws:: java.lang.Exception

minus

public QueryHelper minus(java.lang.String V)
                  throws java.lang.Exception

Throws:: java.lang.Exception

minus

public QueryHelper minus(char V)
                  throws java.lang.Exception

Throws:: java.lang.Exception

minus

public QueryHelper minus(boolean V)
                  throws java.lang.Exception

Throws:: java.lang.Exception

minus

public QueryHelper minus(int V)
                  throws java.lang.Exception

Throws:: java.lang.Exception

minus

public QueryHelper minus(long V)
                  throws java.lang.Exception

Throws:: java.lang.Exception

minus

public QueryHelper minus(float V)
                  throws java.lang.Exception

Throws:: java.lang.Exception

minus

public QueryHelper minus(double V)
                  throws java.lang.Exception

Throws:: java.lang.Exception

minus

public QueryHelper minus(java.time.ZonedDateTime ZDT)
                  throws java.lang.Exception

Throws:: java.lang.Exception

minus

public QueryHelper minus(java.time.LocalDate LDT)
                  throws java.lang.Exception

Throws:: java.lang.Exception

multiply

public QueryHelper multiply(ColumnDefinition Col)
                     throws java.lang.Exception

Throws:: java.lang.Exception

multiply

public QueryHelper multiply(java.lang.String V)
                     throws java.lang.Exception

Throws:: java.lang.Exception

multiply

public QueryHelper multiply(char V)
                     throws java.lang.Exception

Throws:: java.lang.Exception

multiply

public QueryHelper multiply(boolean V)
                     throws java.lang.Exception

Throws:: java.lang.Exception

multiply

public QueryHelper multiply(int V)
                     throws java.lang.Exception

Throws:: java.lang.Exception

multiply

public QueryHelper multiply(long V)
                     throws java.lang.Exception

Throws:: java.lang.Exception

multiply

public QueryHelper multiply(float V)
                     throws java.lang.Exception

Throws:: java.lang.Exception

multiply

public QueryHelper multiply(double V)
                     throws java.lang.Exception

Throws:: java.lang.Exception

divide

public QueryHelper divide(ColumnDefinition Col)
                   throws java.lang.Exception

Throws:: java.lang.Exception

divide

public QueryHelper divide(java.lang.String V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

divide

public QueryHelper divide(char V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

divide

public QueryHelper divide(boolean V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

divide

public QueryHelper divide(int V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

divide

public QueryHelper divide(long V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

divide

public QueryHelper divide(float V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

divide

public QueryHelper divide(double V)
                   throws java.lang.Exception

Throws:: java.lang.Exception

isNull

public QueryHelper isNull(Nullable Col)
                   throws java.lang.Exception

Throws:: java.lang.Exception

isNotNull

public QueryHelper isNotNull(Nullable Col)
                      throws java.lang.Exception

Throws:: java.lang.Exception

like

public QueryHelper like(Type_StringPrimitive Col,
                        java.lang.String V)
                 throws java.lang.Exception

Throws:: java.lang.Exception

like

public QueryHelper like(Type_StringPrimitive Col,
                        java.lang.String V,
                        boolean caseInsensitive)
                 throws java.lang.Exception

Throws:: java.lang.Exception

like

public QueryHelper like(Type_StringPrimitive Col,
                        java.lang.String V,
                        boolean caseInsensitive,
                        boolean not)
                 throws java.lang.Exception

Throws:: java.lang.Exception

like

public QueryHelper like(Type_StringCollection Col,
                        java.lang.String V)
                 throws java.lang.Exception

Throws:: java.lang.Exception

like

public QueryHelper like(Type_StringCollection Col,
                        java.lang.String V,
                        boolean caseInsensitive)
                 throws java.lang.Exception

Throws:: java.lang.Exception

like

public QueryHelper like(Type_StringCollection Col,
                        java.lang.String V,
                        boolean caseInsensitive,
                        boolean not)
                 throws java.lang.Exception

Throws:: java.lang.Exception

like

public QueryHelper like(Type_StringCollection Col,
                        java.lang.String[] V)
                 throws java.lang.Exception

Throws:: java.lang.Exception

like

public QueryHelper like(Type_StringCollection Col,
                        java.lang.String[] V,
                        boolean caseInsensitive)
                 throws java.lang.Exception

Throws:: java.lang.Exception

like

public QueryHelper like(Type_StringCollection Col,
                        java.lang.String[] V,
                        boolean caseInsensitive,
                        boolean not)
                 throws java.lang.Exception

Throws:: java.lang.Exception

like

public QueryHelper like(Type_StringCollection Col,
                        java.util.Collection<java.lang.String> V)
                 throws java.lang.Exception

Throws:: java.lang.Exception

like

public QueryHelper like(Type_StringCollection Col,
                        java.util.Collection<java.lang.String> V,
                        boolean caseInsensitive)
                 throws java.lang.Exception

Throws:: java.lang.Exception

like

public QueryHelper like(Type_StringCollection Col,
                        java.util.Collection<java.lang.String> V,
                        boolean caseInsensitive,
                        boolean not)
                 throws java.lang.Exception

Throws:: java.lang.Exception

like

public QueryHelper like(Type_StringPrimitive[] Cols,
                        java.lang.String V)
                 throws java.lang.Exception

Throws:: java.lang.Exception

like

public QueryHelper like(Type_StringPrimitive[] Cols,
                        java.lang.String V,
                        boolean caseInsensitive)
                 throws java.lang.Exception

Throws:: java.lang.Exception

like

public QueryHelper like(Type_StringPrimitive[] Cols,
                        java.lang.String V,
                        boolean caseInsensitive,
                        boolean not)
                 throws java.lang.Exception

Throws:: java.lang.Exception

like

public QueryHelper like(Type_StringPrimitive Col,
                        java.lang.String[] V,
                        boolean or,
                        boolean caseInsensitive)
                 throws java.lang.Exception

Throws:: java.lang.Exception

like

public QueryHelper like(Type_StringPrimitive[] Cols,
                        java.lang.String[] V,
                        boolean or,
                        boolean caseInsensitive)
                 throws java.lang.Exception

Throws:: java.lang.Exception

array

protected static void array(java.lang.StringBuilder Str,
                            java.lang.String[] V)

any

public QueryHelper any(Type_StringCollection Col,
                       java.lang.String v)

any

public QueryHelper any(Type_StringCollection Col,
                       java.lang.String[] V)
                throws java.lang.Exception

Throws:: java.lang.Exception

any

public QueryHelper any(Type_StringCollection Col,
                       java.util.Collection<java.lang.String> Vals)

any

public QueryHelper any(Type_IntegerCollection Col,
                       int v)

any

public QueryHelper any(Type_IntegerCollection Col,
                       int[] Vals)

any

public QueryHelper any(Type_CharCollection Col,
                       char v)

any

public QueryHelper any(Type_CharCollection Col,
                       char[] Vals)

groupBy

public QueryHelper groupBy(ColumnDefinition Col)
                    throws java.lang.Exception

Throws:: java.lang.Exception

groupBy

public QueryHelper groupBy(QueryHelper.CaseClause clause)
                    throws java.lang.Exception

Throws:: java.lang.Exception

orderByBase

protected void orderByBase()
                    throws java.lang.Exception

Throws:: java.lang.Exception

orderBy

public QueryHelper orderBy(ColumnDefinition Col,
                           boolean Asc)
                    throws java.lang.Exception

Throws:: java.lang.Exception

orderByCountStar

public QueryHelper orderByCountStar(boolean Asc)
                             throws java.lang.Exception

Throws:: java.lang.Exception

orderBy

public QueryHelper orderBy(ColumnDefinition Col,
                           boolean Asc,
                           boolean NullsLast)
                    throws java.lang.Exception

Throws:: java.lang.Exception

ageBetween
```
public QueryHelper ageBetween(Type_DatetimePrimitive Col,
                              int[] ageRange)
```
Generates a BETWEEN statement based on the age range provided. Following with the standard Between semantics, the range is considered fully inclusive, i.e., x <= age <= y.

Parameters:

Col -

ageRange -

Returns:

ageGreaterThan

public QueryHelper ageGreaterThan(Type_DatetimePrimitive Col,
                                  int Age)
                           throws java.lang.Exception

Throws:: java.lang.Exception

ageGreaterThanOrEqual

public QueryHelper ageGreaterThanOrEqual(Type_DatetimePrimitive Col,
                                         int Age)
                                  throws java.lang.Exception

Throws:: java.lang.Exception

ageLessThan

public QueryHelper ageLessThan(Type_DatetimePrimitive Col,
                               int Age)
                        throws java.lang.Exception

Throws:: java.lang.Exception

ageLessThanOrEqual

public QueryHelper ageLessThanOrEqual(Type_DatetimePrimitive Col,
                                      int Age)
                               throws java.lang.Exception

Throws:: java.lang.Exception

ageEquals

public QueryHelper ageEquals(Type_DatetimePrimitive Col,
                             int Age)
                      throws java.lang.Exception

Throws:: java.lang.Exception

ageGreaterThan

public QueryHelper ageGreaterThan(Type_DatetimePrimitive ColStart,
                                  Type_DatetimePrimitive ColEnd,
                                  DurationUtil.IntervalEnum Type,
                                  int Count)
                           throws java.lang.Exception

Throws:: java.lang.Exception

ageGreaterThanOrEqual

public QueryHelper ageGreaterThanOrEqual(Type_DatetimePrimitive ColStart,
                                         Type_DatetimePrimitive ColEnd,
                                         DurationUtil.IntervalEnum Type,
                                         int Count)
                                  throws java.lang.Exception

Throws:: java.lang.Exception

ageLessThan

public QueryHelper ageLessThan(Type_DatetimePrimitive ColStart,
                               Type_DatetimePrimitive ColEnd,
                               DurationUtil.IntervalEnum Type,
                               int Count)
                        throws java.lang.Exception

Throws:: java.lang.Exception

ageLessThanOrEqual

public QueryHelper ageLessThanOrEqual(Type_DatetimePrimitive ColStart,
                                      Type_DatetimePrimitive ColEnd,
                                      DurationUtil.IntervalEnum Type,
                                      int Count)
                               throws java.lang.Exception

Throws:: java.lang.Exception

ageEquals

public QueryHelper ageEquals(Type_DatetimePrimitive ColStart,
                             Type_DatetimePrimitive ColEnd,
                             DurationUtil.IntervalEnum Type,
                             int Count)
                      throws java.lang.Exception

Throws:: java.lang.Exception

within

public QueryHelper within(Type_DatetimePrimitive Col,
                          Type_DatetimePrimitive ColStart,
                          long durationCount,
                          DurationUtil.IntervalEnum Type)
                   throws java.lang.Exception

If Duration is positive, implements the condition Col >= ColStart && Col < ColStart + interval specified.
If Duration is negative, implements the condition Col > ColStart - interval specified && Col <= ColStart (with the interval negated).

Parameters:: Col -; ColStart -; durationCount -; Type -
Returns:
Throws:: java.lang.Exception

newLine

public QueryHelper newLine()
                    throws java.lang.Exception

Throws:: java.lang.Exception

newLine

public QueryHelper newLine(java.lang.String NextHeader)
                    throws java.lang.Exception

Throws:: java.lang.Exception

padding

public QueryHelper padding(int spaces)
                    throws java.lang.Exception

Throws:: java.lang.Exception

exists

public QueryHelper exists(SelectQuery subQ)

notExists

public QueryHelper notExists(SelectQuery subQ)

toString
```
public java.lang.String toString()
```
Overrides:

toString in class java.lang.Object

addSuperQueryContext

public QueryHelper addSuperQueryContext(java.lang.String schemaName,
                                        java.lang.String tableName)

Class QueryHelper

Nested Class Summary

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

_SchemaName

_TableName

_ST

_FullSelect

_C

_QueryStr

_Section

_Where

_NoWhereClause

_WherePos

_Cardinality

_SubSelectCount

Constructor Detail

QueryHelper

Method Detail

isFullSelectQuery

clear

isWhereClauseEmpty

getCardinality

getColumns

valuesBase

selectColumnBase

selectColumn

selectDistinctColumn

selectCountStar

selectCountDistinct

selectColumn

selectColumn

selectCase

fromTable

fromSubSelect

where

subWhere

subWhere

subWhere

and

or

not

openPar

closePar

opCol

opOK

opValBase

opVal

opVal

opVal

opVal

opVal

opVal

opVal

opVal

opVal

opVal

getWhereClause

getWhereClause

values

from

from

tableSample

from

setColumn

set

set

set

set

set

set

set

set

set

set

set

set