Uses of Class
tilda.db.QueryHelper

Packages that use QueryHelper

Package	Description
tilda.db

Uses of QueryHelper in tilda.db

Subclasses of QueryHelper in tilda.db

Modifier and Type	Class	Description
class	DeleteQuery	LDH-NOTE This class helps build queries more safely, but it's not a compile-time tool.
class	InsertQuery	LDH-NOTE This class helps build queries more safely, but it's not a compile-time tool.
class	SelectQuery	LDH-NOTE This class helps build queries more safely, but it's not a compile-time tool.
class	SelectQueryParsedAndValidated	LDH-NOTE This class allwos to pass in a full string-based where-clause that will be validated against the TildaSQL parser
class	UpdateQuery	LDH-NOTE This class helps build queries more safely, but it's not a compile-time tool.

Methods in tilda.db that return QueryHelper

Modifier and Type	Method	Description
QueryHelper	QueryHelper.addSuperQueryContext(java.lang.String schemaName, java.lang.String tableName)
QueryHelper	QueryHelper.ageBetween(Type_DatetimePrimitive Col, int[] ageRange)	Generates a BETWEEN statement based on the age range provided.
QueryHelper	QueryHelper.ageEquals(Type_DatetimePrimitive Col, int Age)
QueryHelper	QueryHelper.ageEquals(Type_DatetimePrimitive ColStart, Type_DatetimePrimitive ColEnd, DurationUtil.IntervalEnum Type, int Count)
QueryHelper	QueryHelper.ageGreaterThan(Type_DatetimePrimitive Col, int Age)
QueryHelper	QueryHelper.ageGreaterThan(Type_DatetimePrimitive ColStart, Type_DatetimePrimitive ColEnd, DurationUtil.IntervalEnum Type, int Count)
QueryHelper	QueryHelper.ageGreaterThanOrEqual(Type_DatetimePrimitive Col, int Age)
QueryHelper	QueryHelper.ageGreaterThanOrEqual(Type_DatetimePrimitive ColStart, Type_DatetimePrimitive ColEnd, DurationUtil.IntervalEnum Type, int Count)
QueryHelper	QueryHelper.ageLessThan(Type_DatetimePrimitive Col, int Age)
QueryHelper	QueryHelper.ageLessThan(Type_DatetimePrimitive ColStart, Type_DatetimePrimitive ColEnd, DurationUtil.IntervalEnum Type, int Count)
QueryHelper	QueryHelper.ageLessThanOrEqual(Type_DatetimePrimitive Col, int Age)
QueryHelper	QueryHelper.ageLessThanOrEqual(Type_DatetimePrimitive ColStart, Type_DatetimePrimitive ColEnd, DurationUtil.IntervalEnum Type, int Count)
QueryHelper	QueryHelper.and()
QueryHelper	QueryHelper.any(Type_CharCollection Col, char v)
QueryHelper	QueryHelper.any(Type_CharCollection Col, char[] Vals)
QueryHelper	QueryHelper.any(Type_IntegerCollection Col, int v)
QueryHelper	QueryHelper.any(Type_IntegerCollection Col, int[] Vals)
QueryHelper	QueryHelper.any(Type_StringCollection Col, java.lang.String v)
QueryHelper	QueryHelper.any(Type_StringCollection Col, java.lang.String[] V)
QueryHelper	QueryHelper.any(Type_StringCollection Col, java.util.Collection<java.lang.String> Vals)
QueryHelper	QueryHelper.closePar()
protected QueryHelper	QueryHelper.colOpBase(ColumnDefinition Col, java.lang.String coalesceValStr, QueryHelper.Op O, java.lang.String ValStr)
protected QueryHelper	QueryHelper.compareBase(ColumnDefinition Col1, ColumnDefinition Col2, QueryHelper.Op O)
QueryHelper	QueryHelper.divide(boolean V)
QueryHelper	QueryHelper.divide(char V)
QueryHelper	QueryHelper.divide(double V)
QueryHelper	QueryHelper.divide(float V)
QueryHelper	QueryHelper.divide(int V)
QueryHelper	QueryHelper.divide(long V)
QueryHelper	QueryHelper.divide(java.lang.String V)
QueryHelper	QueryHelper.divide(ColumnDefinition Col)
QueryHelper	QueryHelper.equals(boolean V)
QueryHelper	QueryHelper.equals(char V)
QueryHelper	QueryHelper.equals(double V)
QueryHelper	QueryHelper.equals(float V)
QueryHelper	QueryHelper.equals(int V)
QueryHelper	QueryHelper.equals(long V)
QueryHelper	QueryHelper.equals(short V)
QueryHelper	QueryHelper.equals(java.lang.String V)
QueryHelper	QueryHelper.equals(java.time.ZonedDateTime ZDT)
QueryHelper	QueryHelper.equals(ColumnDefinition Col1)
QueryHelper	QueryHelper.equals(Type_BooleanPrimitive Col, boolean V)
QueryHelper	QueryHelper.equals(Type_BooleanPrimitive Col, java.lang.Boolean coalesceVal, boolean V)
QueryHelper	QueryHelper.equals(Type_BooleanPrimitive Col1, Type_BooleanPrimitive Col2)
QueryHelper	QueryHelper.equals(Type_CharPrimitive Col, char V)
QueryHelper	QueryHelper.equals(Type_CharPrimitive Col, char coalesceVal, char V)
QueryHelper	QueryHelper.equals(Type_CharPrimitive Col1, Type_CharPrimitive Col2)
QueryHelper	QueryHelper.equals(Type_DatePrimitive Col, java.time.LocalDate LDT)
QueryHelper	QueryHelper.equals(Type_DatePrimitive Col, java.time.LocalDate coalesceVal, java.time.LocalDate V)
QueryHelper	QueryHelper.equals(Type_DatePrimitive Col1, Type_DatePrimitive Col2)
QueryHelper	QueryHelper.equals(Type_DatetimePrimitive Col, java.time.ZonedDateTime ZDT)
QueryHelper	QueryHelper.equals(Type_DatetimePrimitive Col, java.time.ZonedDateTime coalesceVal, java.time.ZonedDateTime V)
QueryHelper	QueryHelper.equals(Type_DatetimePrimitive Col1, Type_DatetimePrimitive Col2)
QueryHelper	QueryHelper.equals(Type_DoublePrimitive Col, double V)
QueryHelper	QueryHelper.equals(Type_DoublePrimitive Col, java.lang.Double coalesceVal, double V)
QueryHelper	QueryHelper.equals(Type_DoublePrimitive Col1, Type_DoublePrimitive Col2)
QueryHelper	QueryHelper.equals(Type_FloatPrimitive Col, float V)
QueryHelper	QueryHelper.equals(Type_FloatPrimitive Col, java.lang.Float coalesceVal, float V)
QueryHelper	QueryHelper.equals(Type_FloatPrimitive Col1, Type_FloatPrimitive Col2)
QueryHelper	QueryHelper.equals(Type_IntegerPrimitive Col, int V)
QueryHelper	QueryHelper.equals(Type_IntegerPrimitive Col, java.lang.Integer coalesceVal, int V)
QueryHelper	QueryHelper.equals(Type_IntegerPrimitive Col1, Type_IntegerPrimitive Col2)
QueryHelper	QueryHelper.equals(Type_IntegerPrimitive Col1, Type_ShortPrimitive Col2)
QueryHelper	QueryHelper.equals(Type_LongPrimitive Col, long V)
QueryHelper	QueryHelper.equals(Type_LongPrimitive Col, java.lang.Long coalesceVal, long V)
QueryHelper	QueryHelper.equals(Type_LongPrimitive Col1, Type_LongPrimitive Col2)
QueryHelper	QueryHelper.equals(Type_LongPrimitive Col1, Type_ShortPrimitive Col2)
QueryHelper	QueryHelper.equals(Type_ShortPrimitive Col, short V)
QueryHelper	QueryHelper.equals(Type_ShortPrimitive Col, java.lang.Short coalesceVal, short V)
QueryHelper	QueryHelper.equals(Type_ShortPrimitive Col1, Type_ShortPrimitive Col2)
QueryHelper	QueryHelper.equals(Type_StringPrimitive Col, java.lang.String V)
QueryHelper	QueryHelper.equals(Type_StringPrimitive Col, java.lang.String coalesceVal, java.lang.String V)
QueryHelper	QueryHelper.equals(Type_StringPrimitive Col1, Type_StringPrimitive Col2)
QueryHelper	QueryHelper.exists(SelectQuery subQ)
QueryHelper	QueryHelper.from()
QueryHelper	QueryHelper.from(java.lang.String SchemaName, java.lang.String TableName)
QueryHelper	QueryHelper.from(SelectQuery Q)
protected QueryHelper	QueryHelper.fromSubSelect(SelectQuery FullSelect)
protected QueryHelper	QueryHelper.fromTable(java.lang.String SchemaName, java.lang.String TableName)
QueryHelper	QueryHelper.groupBy(QueryHelper.CaseClause clause)
QueryHelper	QueryHelper.groupBy(ColumnDefinition Col)
QueryHelper	QueryHelper.gt(Type_BooleanPrimitive Col, boolean V)
QueryHelper	QueryHelper.gt(Type_BooleanPrimitive Col, java.lang.Boolean coalesceVal, boolean V)
QueryHelper	QueryHelper.gt(Type_BooleanPrimitive Col1, Type_BooleanPrimitive Col2)
QueryHelper	QueryHelper.gt(Type_CharPrimitive Col, char V)
QueryHelper	QueryHelper.gt(Type_CharPrimitive Col, char coalesceVal, char V)
QueryHelper	QueryHelper.gt(Type_CharPrimitive Col1, Type_CharPrimitive Col2)
QueryHelper	QueryHelper.gt(Type_DatePrimitive Col, java.time.LocalDate LDT)
QueryHelper	QueryHelper.gt(Type_DatePrimitive Col, java.time.LocalDate coalesceVal, java.time.LocalDate V)
QueryHelper	QueryHelper.gt(Type_DatePrimitive Col1, Type_DatePrimitive Col2)
QueryHelper	QueryHelper.gt(Type_DatetimePrimitive Col, java.time.LocalDate ZDT)
QueryHelper	QueryHelper.gt(Type_DatetimePrimitive Col, java.time.LocalDate coalesceVal, java.time.LocalDate V)
QueryHelper	QueryHelper.gt(Type_DatetimePrimitive Col, java.time.ZonedDateTime ZDT)
QueryHelper	QueryHelper.gt(Type_DatetimePrimitive Col, java.time.ZonedDateTime coalesceVal, java.time.ZonedDateTime V)
QueryHelper	QueryHelper.gt(Type_DatetimePrimitive Col1, Type_DatetimePrimitive Col2)
QueryHelper	QueryHelper.gt(Type_DoublePrimitive Col, double V)
QueryHelper	QueryHelper.gt(Type_DoublePrimitive Col, java.lang.Double coalesceVal, double V)
QueryHelper	QueryHelper.gt(Type_DoublePrimitive Col1, Type_DoublePrimitive Col2)
QueryHelper	QueryHelper.gt(Type_FloatPrimitive Col, float V)
QueryHelper	QueryHelper.gt(Type_FloatPrimitive Col, java.lang.Float coalesceVal, float V)
QueryHelper	QueryHelper.gt(Type_FloatPrimitive Col1, Type_FloatPrimitive Col2)
QueryHelper	QueryHelper.gt(Type_IntegerPrimitive Col, int V)
QueryHelper	QueryHelper.gt(Type_IntegerPrimitive Col, java.lang.Integer coalesceVal, int V)
QueryHelper	QueryHelper.gt(Type_IntegerPrimitive Col1, Type_IntegerPrimitive Col2)
QueryHelper	QueryHelper.gt(Type_LongPrimitive Col, long V)
QueryHelper	QueryHelper.gt(Type_LongPrimitive Col, java.lang.Long coalesceVal, long V)
QueryHelper	QueryHelper.gt(Type_LongPrimitive Col1, Type_LongPrimitive Col2)
QueryHelper	QueryHelper.gt(Type_ShortPrimitive Col, short V)
QueryHelper	QueryHelper.gt(Type_ShortPrimitive Col, java.lang.Short coalesceVal, short V)
QueryHelper	QueryHelper.gt(Type_ShortPrimitive Col1, Type_ShortPrimitive Col2)
QueryHelper	QueryHelper.gt(Type_StringPrimitive Col, java.lang.String V)
QueryHelper	QueryHelper.gt(Type_StringPrimitive Col, java.lang.String coalesceVal, java.lang.String V)
QueryHelper	QueryHelper.gt(Type_StringPrimitive Col1, Type_StringPrimitive Col2)
QueryHelper	QueryHelper.gte(Type_BooleanPrimitive Col, boolean V)
QueryHelper	QueryHelper.gte(Type_BooleanPrimitive Col, java.lang.Boolean coalesceVal, boolean V)
QueryHelper	QueryHelper.gte(Type_BooleanPrimitive Col1, Type_BooleanPrimitive Col2)
QueryHelper	QueryHelper.gte(Type_CharPrimitive Col, char V)
QueryHelper	QueryHelper.gte(Type_CharPrimitive Col, char coalesceVal, char V)
QueryHelper	QueryHelper.gte(Type_CharPrimitive Col1, Type_CharPrimitive Col2)
QueryHelper	QueryHelper.gte(Type_DatePrimitive Col, java.time.LocalDate LDT)
QueryHelper	QueryHelper.gte(Type_DatePrimitive Col, java.time.LocalDate coalesceVal, java.time.LocalDate V)
QueryHelper	QueryHelper.gte(Type_DatePrimitive Col1, Type_DatePrimitive Col2)
QueryHelper	QueryHelper.gte(Type_DatetimePrimitive Col, java.time.LocalDate ZDT)
QueryHelper	QueryHelper.gte(Type_DatetimePrimitive Col, java.time.LocalDate coalesceVal, java.time.LocalDate V)
QueryHelper	QueryHelper.gte(Type_DatetimePrimitive Col, java.time.ZonedDateTime ZDT)
QueryHelper	QueryHelper.gte(Type_DatetimePrimitive Col, java.time.ZonedDateTime coalesceVal, java.time.ZonedDateTime V)
QueryHelper	QueryHelper.gte(Type_DatetimePrimitive Col1, Type_DatetimePrimitive Col2)
QueryHelper	QueryHelper.gte(Type_DoublePrimitive Col, double V)
QueryHelper	QueryHelper.gte(Type_DoublePrimitive Col, java.lang.Double coalesceVal, double V)
QueryHelper	QueryHelper.gte(Type_DoublePrimitive Col1, Type_DoublePrimitive Col2)
QueryHelper	QueryHelper.gte(Type_FloatPrimitive Col, float V)
QueryHelper	QueryHelper.gte(Type_FloatPrimitive Col, java.lang.Float coalesceVal, float V)
QueryHelper	QueryHelper.gte(Type_FloatPrimitive Col1, Type_FloatPrimitive Col2)
QueryHelper	QueryHelper.gte(Type_IntegerPrimitive Col, int V)
QueryHelper	QueryHelper.gte(Type_IntegerPrimitive Col, java.lang.Integer coalesceVal, int V)
QueryHelper	QueryHelper.gte(Type_IntegerPrimitive Col1, Type_IntegerPrimitive Col2)
QueryHelper	QueryHelper.gte(Type_LongPrimitive Col, long V)
QueryHelper	QueryHelper.gte(Type_LongPrimitive Col, java.lang.Long coalesceVal, long V)
QueryHelper	QueryHelper.gte(Type_LongPrimitive Col1, Type_LongPrimitive Col2)
QueryHelper	QueryHelper.gte(Type_ShortPrimitive Col, short V)
QueryHelper	QueryHelper.gte(Type_ShortPrimitive Col, java.lang.Short coalesceVal, short V)
QueryHelper	QueryHelper.gte(Type_ShortPrimitive Col1, Type_ShortPrimitive Col2)
QueryHelper	QueryHelper.gte(Type_StringPrimitive Col, java.lang.String V)
QueryHelper	QueryHelper.gte(Type_StringPrimitive Col, java.lang.String coalesceVal, java.lang.String V)
QueryHelper	QueryHelper.gte(Type_StringPrimitive Col1, Type_StringPrimitive Col2)
QueryHelper	QueryHelper.in(ColumnDefinition Col, SelectQuery Q)
QueryHelper	QueryHelper.in(ColumnDefinition Col, SelectQuery Q, boolean not)
QueryHelper	QueryHelper.in(Type_CharPrimitive Col, char[] V)
QueryHelper	QueryHelper.in(Type_CharPrimitive Col, char[] V, boolean not)
QueryHelper	QueryHelper.in(Type_CharPrimitive Col, char coalesceVal, char[] V, boolean not)
QueryHelper	QueryHelper.in(Type_DatePrimitive Col, java.time.LocalDate[] V)
QueryHelper	QueryHelper.in(Type_DatePrimitive Col, java.time.LocalDate[] V, boolean not)
QueryHelper	QueryHelper.in(Type_DatePrimitive Col, java.time.LocalDate coalesceVal, java.time.LocalDate[] V, boolean not)
QueryHelper	QueryHelper.in(Type_DatePrimitive Col, java.time.LocalDate coalesceVal, java.util.Collection<java.time.LocalDate> V, boolean not)
QueryHelper	QueryHelper.in(Type_DatePrimitive Col, java.util.Collection<java.time.LocalDate> V)
QueryHelper	QueryHelper.in(Type_DatePrimitive Col, java.util.Collection<java.time.LocalDate> V, boolean not)
QueryHelper	QueryHelper.in(Type_DatetimePrimitive Col, java.time.ZonedDateTime[] V)
QueryHelper	QueryHelper.in(Type_DatetimePrimitive Col, java.time.ZonedDateTime[] V, boolean not)
QueryHelper	QueryHelper.in(Type_DatetimePrimitive Col, java.time.ZonedDateTime coalesceVal, java.time.ZonedDateTime[] V, boolean not)
QueryHelper	QueryHelper.in(Type_DatetimePrimitive Col, java.time.ZonedDateTime coalesceVal, java.util.Collection<java.time.ZonedDateTime> V, boolean not)
QueryHelper	QueryHelper.in(Type_DatetimePrimitive Col, java.util.Collection<java.time.ZonedDateTime> V)
QueryHelper	QueryHelper.in(Type_DatetimePrimitive Col, java.util.Collection<java.time.ZonedDateTime> V, boolean not)
QueryHelper	QueryHelper.in(Type_DoublePrimitive Col, double[] V)
QueryHelper	QueryHelper.in(Type_DoublePrimitive Col, double[] V, boolean not)
QueryHelper	QueryHelper.in(Type_DoublePrimitive Col, java.lang.Double coalesceVal, double[] V, boolean not)
QueryHelper	QueryHelper.in(Type_FloatPrimitive Col, float[] V)
QueryHelper	QueryHelper.in(Type_FloatPrimitive Col, float[] V, boolean not)
QueryHelper	QueryHelper.in(Type_FloatPrimitive Col, java.lang.Float coalesceVal, float[] V, boolean not)
QueryHelper	QueryHelper.in(Type_IntegerPrimitive Col, int[] V)
QueryHelper	QueryHelper.in(Type_IntegerPrimitive Col, int[] V, boolean not)
QueryHelper	QueryHelper.in(Type_IntegerPrimitive Col, java.lang.Integer coalesceVal, int[] V, boolean not)
QueryHelper	QueryHelper.in(Type_LongPrimitive Col, long[] V)
QueryHelper	QueryHelper.in(Type_LongPrimitive Col, long[] V, boolean not)
QueryHelper	QueryHelper.in(Type_LongPrimitive Col, java.lang.Long coalesceVal, long[] V, boolean not)
QueryHelper	QueryHelper.in(Type_ShortPrimitive Col, short[] V)
QueryHelper	QueryHelper.in(Type_ShortPrimitive Col, short[] V, boolean not)
QueryHelper	QueryHelper.in(Type_ShortPrimitive Col, java.lang.Short coalesceVal, short[] V, boolean not)
QueryHelper	QueryHelper.in(Type_StringCollection Col, java.lang.String[] V)
QueryHelper	QueryHelper.in(Type_StringCollection Col, java.lang.String[] V, boolean not)
QueryHelper	QueryHelper.in(Type_StringCollection Col, java.util.Collection<java.lang.String> V)
QueryHelper	QueryHelper.in(Type_StringCollection Col, java.util.Collection<java.lang.String> V, boolean not)
QueryHelper	QueryHelper.in(Type_StringPrimitive Col, java.lang.String[] V)
QueryHelper	QueryHelper.in(Type_StringPrimitive Col, java.lang.String[] V, boolean not)
QueryHelper	QueryHelper.in(Type_StringPrimitive Col, java.lang.String coalesceVal, java.lang.String[] V, boolean not)
QueryHelper	QueryHelper.in(Type_StringPrimitive Col, java.lang.String coalesceVal, java.util.Collection<java.lang.String> V, boolean not)
QueryHelper	QueryHelper.in(Type_StringPrimitive Col, java.util.Collection<java.lang.String> V)
QueryHelper	QueryHelper.in(Type_StringPrimitive Col, java.util.Collection<java.lang.String> V, boolean not)
QueryHelper	QueryHelper.isNotNull(Nullable Col)
QueryHelper	QueryHelper.isNull(Nullable Col)
QueryHelper	QueryHelper.like(Type_StringCollection Col, java.lang.String V)
QueryHelper	QueryHelper.like(Type_StringCollection Col, java.lang.String[] V)
QueryHelper	QueryHelper.like(Type_StringCollection Col, java.lang.String[] V, boolean caseInsensitive)
QueryHelper	QueryHelper.like(Type_StringCollection Col, java.lang.String[] V, boolean caseInsensitive, boolean not)
QueryHelper	QueryHelper.like(Type_StringCollection Col, java.lang.String V, boolean caseInsensitive)
QueryHelper	QueryHelper.like(Type_StringCollection Col, java.lang.String V, boolean caseInsensitive, boolean not)
QueryHelper	QueryHelper.like(Type_StringCollection Col, java.util.Collection<java.lang.String> V)
QueryHelper	QueryHelper.like(Type_StringCollection Col, java.util.Collection<java.lang.String> V, boolean caseInsensitive)
QueryHelper	QueryHelper.like(Type_StringCollection Col, java.util.Collection<java.lang.String> V, boolean caseInsensitive, boolean not)
QueryHelper	QueryHelper.like(Type_StringPrimitive[] Cols, java.lang.String V)
QueryHelper	QueryHelper.like(Type_StringPrimitive[] Cols, java.lang.String[] V, boolean or, boolean caseInsensitive)
QueryHelper	QueryHelper.like(Type_StringPrimitive[] Cols, java.lang.String V, boolean caseInsensitive)
QueryHelper	QueryHelper.like(Type_StringPrimitive[] Cols, java.lang.String V, boolean caseInsensitive, boolean not)
QueryHelper	QueryHelper.like(Type_StringPrimitive Col, java.lang.String V)
QueryHelper	QueryHelper.like(Type_StringPrimitive Col, java.lang.String[] V, boolean or, boolean caseInsensitive)
QueryHelper	QueryHelper.like(Type_StringPrimitive Col, java.lang.String V, boolean caseInsensitive)
QueryHelper	QueryHelper.like(Type_StringPrimitive Col, java.lang.String V, boolean caseInsensitive, boolean not)
QueryHelper	QueryHelper.lt(Type_BooleanPrimitive Col, boolean V)
QueryHelper	QueryHelper.lt(Type_BooleanPrimitive Col, java.lang.Boolean coalesceVal, boolean V)
QueryHelper	QueryHelper.lt(Type_BooleanPrimitive Col1, Type_BooleanPrimitive Col2)
QueryHelper	QueryHelper.lt(Type_CharPrimitive Col, char V)
QueryHelper	QueryHelper.lt(Type_CharPrimitive Col, char coalesceVal, char V)
QueryHelper	QueryHelper.lt(Type_CharPrimitive Col1, Type_CharPrimitive Col2)
QueryHelper	QueryHelper.lt(Type_DatePrimitive Col, java.time.LocalDate LDT)
QueryHelper	QueryHelper.lt(Type_DatePrimitive Col, java.time.LocalDate coalesceVal, java.time.LocalDate V)
QueryHelper	QueryHelper.lt(Type_DatePrimitive Col1, Type_DatePrimitive Col2)
QueryHelper	QueryHelper.lt(Type_DatetimePrimitive Col, java.time.LocalDate ZDT)
QueryHelper	QueryHelper.lt(Type_DatetimePrimitive Col, java.time.LocalDate coalesceVal, java.time.LocalDate V)
QueryHelper	QueryHelper.lt(Type_DatetimePrimitive Col, java.time.ZonedDateTime ZDT)
QueryHelper	QueryHelper.lt(Type_DatetimePrimitive Col, java.time.ZonedDateTime coalesceVal, java.time.ZonedDateTime V)
QueryHelper	QueryHelper.lt(Type_DatetimePrimitive Col1, Type_DatetimePrimitive Col2)
QueryHelper	QueryHelper.lt(Type_DoublePrimitive Col, double V)
QueryHelper	QueryHelper.lt(Type_DoublePrimitive Col, java.lang.Double coalesceVal, double V)
QueryHelper	QueryHelper.lt(Type_DoublePrimitive Col1, Type_DoublePrimitive Col2)
QueryHelper	QueryHelper.lt(Type_FloatPrimitive Col, float V)
QueryHelper	QueryHelper.lt(Type_FloatPrimitive Col, java.lang.Float coalesceVal, float V)
QueryHelper	QueryHelper.lt(Type_FloatPrimitive Col1, Type_FloatPrimitive Col2)
QueryHelper	QueryHelper.lt(Type_IntegerPrimitive Col, int V)
QueryHelper	QueryHelper.lt(Type_IntegerPrimitive Col, java.lang.Integer coalesceVal, int V)
QueryHelper	QueryHelper.lt(Type_IntegerPrimitive Col1, Type_IntegerPrimitive Col2)
QueryHelper	QueryHelper.lt(Type_LongPrimitive Col, long V)
QueryHelper	QueryHelper.lt(Type_LongPrimitive Col, java.lang.Long coalesceVal, long V)
QueryHelper	QueryHelper.lt(Type_LongPrimitive Col1, Type_LongPrimitive Col2)
QueryHelper	QueryHelper.lt(Type_ShortPrimitive Col, short V)
QueryHelper	QueryHelper.lt(Type_ShortPrimitive Col, java.lang.Short coalesceVal, short V)
QueryHelper	QueryHelper.lt(Type_ShortPrimitive Col1, Type_IntegerPrimitive Col2)
QueryHelper	QueryHelper.lt(Type_ShortPrimitive Col1, Type_LongPrimitive Col2)
QueryHelper	QueryHelper.lt(Type_ShortPrimitive Col1, Type_ShortPrimitive Col2)
QueryHelper	QueryHelper.lt(Type_StringPrimitive Col, java.lang.String V)
QueryHelper	QueryHelper.lt(Type_StringPrimitive Col, java.lang.String coalesceVal, java.lang.String V)
QueryHelper	QueryHelper.lt(Type_StringPrimitive Col1, Type_StringPrimitive Col2)
QueryHelper	QueryHelper.lte(Type_BooleanPrimitive Col, boolean V)
QueryHelper	QueryHelper.lte(Type_BooleanPrimitive Col, java.lang.Boolean coalesceVal, boolean V)
QueryHelper	QueryHelper.lte(Type_BooleanPrimitive Col1, Type_BooleanPrimitive Col2)
QueryHelper	QueryHelper.lte(Type_CharPrimitive Col, char V)
QueryHelper	QueryHelper.lte(Type_CharPrimitive Col, char coalesceVal, char V)
QueryHelper	QueryHelper.lte(Type_CharPrimitive Col1, Type_CharPrimitive Col2)
QueryHelper	QueryHelper.lte(Type_DatePrimitive Col, java.time.LocalDate LDT)
QueryHelper	QueryHelper.lte(Type_DatePrimitive Col, java.time.LocalDate coalesceVal, java.time.LocalDate V)
QueryHelper	QueryHelper.lte(Type_DatePrimitive Col1, Type_DatePrimitive Col2)
QueryHelper	QueryHelper.lte(Type_DatetimePrimitive Col, java.time.LocalDate ZDT)
QueryHelper	QueryHelper.lte(Type_DatetimePrimitive Col, java.time.LocalDate coalesceVal, java.time.LocalDate V)
QueryHelper	QueryHelper.lte(Type_DatetimePrimitive Col, java.time.ZonedDateTime ZDT)
QueryHelper	QueryHelper.lte(Type_DatetimePrimitive Col, java.time.ZonedDateTime coalesceVal, java.time.ZonedDateTime V)
QueryHelper	QueryHelper.lte(Type_DatetimePrimitive Col1, Type_DatetimePrimitive Col2)
QueryHelper	QueryHelper.lte(Type_DoublePrimitive Col, double V)
QueryHelper	QueryHelper.lte(Type_DoublePrimitive Col, java.lang.Double coalesceVal, double V)
QueryHelper	QueryHelper.lte(Type_DoublePrimitive Col1, Type_DoublePrimitive Col2)
QueryHelper	QueryHelper.lte(Type_FloatPrimitive Col, float V)
QueryHelper	QueryHelper.lte(Type_FloatPrimitive Col, java.lang.Float coalesceVal, float V)
QueryHelper	QueryHelper.lte(Type_FloatPrimitive Col1, Type_FloatPrimitive Col2)
QueryHelper	QueryHelper.lte(Type_IntegerPrimitive Col, int V)
QueryHelper	QueryHelper.lte(Type_IntegerPrimitive Col, java.lang.Integer coalesceVal, int V)
QueryHelper	QueryHelper.lte(Type_IntegerPrimitive Col1, Type_IntegerPrimitive Col2)
QueryHelper	QueryHelper.lte(Type_LongPrimitive Col, long V)
QueryHelper	QueryHelper.lte(Type_LongPrimitive Col, java.lang.Long coalesceVal, long V)
QueryHelper	QueryHelper.lte(Type_LongPrimitive Col1, Type_LongPrimitive Col2)
QueryHelper	QueryHelper.lte(Type_ShortPrimitive Col, short V)
QueryHelper	QueryHelper.lte(Type_ShortPrimitive Col, java.lang.Short coalesceVal, short V)
QueryHelper	QueryHelper.lte(Type_ShortPrimitive Col1, Type_ShortPrimitive Col2)
QueryHelper	QueryHelper.lte(Type_StringPrimitive Col, java.lang.String V)
QueryHelper	QueryHelper.lte(Type_StringPrimitive Col, java.lang.String coalesceVal, java.lang.String V)
QueryHelper	QueryHelper.lte(Type_StringPrimitive Col1, Type_StringPrimitive Col2)
QueryHelper	QueryHelper.minus(boolean V)
QueryHelper	QueryHelper.minus(char V)
QueryHelper	QueryHelper.minus(double V)
QueryHelper	QueryHelper.minus(float V)
QueryHelper	QueryHelper.minus(int V)
QueryHelper	QueryHelper.minus(long V)
QueryHelper	QueryHelper.minus(java.lang.String V)
QueryHelper	QueryHelper.minus(java.time.LocalDate LDT)
QueryHelper	QueryHelper.minus(java.time.ZonedDateTime ZDT)
QueryHelper	QueryHelper.minus(ColumnDefinition Col)
QueryHelper	QueryHelper.multiply(boolean V)
QueryHelper	QueryHelper.multiply(char V)
QueryHelper	QueryHelper.multiply(double V)
QueryHelper	QueryHelper.multiply(float V)
QueryHelper	QueryHelper.multiply(int V)
QueryHelper	QueryHelper.multiply(long V)
QueryHelper	QueryHelper.multiply(java.lang.String V)
QueryHelper	QueryHelper.multiply(ColumnDefinition Col)
QueryHelper	QueryHelper.newLine()
QueryHelper	QueryHelper.newLine(java.lang.String NextHeader)
QueryHelper	QueryHelper.not()
QueryHelper	QueryHelper.notEquals(Type_BooleanPrimitive Col, boolean V)
QueryHelper	QueryHelper.notEquals(Type_BooleanPrimitive Col, java.lang.Boolean coalesceVal, boolean V)
QueryHelper	QueryHelper.notEquals(Type_BooleanPrimitive Col1, Type_BooleanPrimitive Col2)
QueryHelper	QueryHelper.notEquals(Type_CharPrimitive Col, char V)
QueryHelper	QueryHelper.notEquals(Type_CharPrimitive Col, char coalesceVal, char V)
QueryHelper	QueryHelper.notEquals(Type_CharPrimitive Col1, Type_CharPrimitive Col2)
QueryHelper	QueryHelper.notEquals(Type_DatePrimitive Col, java.time.LocalDate LDT)
QueryHelper	QueryHelper.notEquals(Type_DatePrimitive Col, java.time.LocalDate coalesceVal, java.time.LocalDate V)
QueryHelper	QueryHelper.notEquals(Type_DatePrimitive Col1, Type_DatePrimitive Col2)
QueryHelper	QueryHelper.notEquals(Type_DatetimePrimitive Col, java.time.ZonedDateTime ZDT)
QueryHelper	QueryHelper.notEquals(Type_DatetimePrimitive Col, java.time.ZonedDateTime coalesceVal, java.time.ZonedDateTime V)
QueryHelper	QueryHelper.notEquals(Type_DatetimePrimitive Col1, Type_DatetimePrimitive Col2)
QueryHelper	QueryHelper.notEquals(Type_DoublePrimitive Col, double V)
QueryHelper	QueryHelper.notEquals(Type_DoublePrimitive Col, java.lang.Double coalesceVal, double V)
QueryHelper	QueryHelper.notEquals(Type_DoublePrimitive Col1, Type_DoublePrimitive Col2)
QueryHelper	QueryHelper.notEquals(Type_FloatPrimitive Col, float V)
QueryHelper	QueryHelper.notEquals(Type_FloatPrimitive Col, java.lang.Float coalesceVal, float V)
QueryHelper	QueryHelper.notEquals(Type_FloatPrimitive Col1, Type_FloatPrimitive Col2)
QueryHelper	QueryHelper.notEquals(Type_IntegerPrimitive Col, int V)
QueryHelper	QueryHelper.notEquals(Type_IntegerPrimitive Col, java.lang.Integer coalesceVal, int V)
QueryHelper	QueryHelper.notEquals(Type_IntegerPrimitive Col1, Type_IntegerPrimitive Col2)
QueryHelper	QueryHelper.notEquals(Type_LongPrimitive Col, long V)
QueryHelper	QueryHelper.notEquals(Type_LongPrimitive Col, java.lang.Long coalesceVal, long V)
QueryHelper	QueryHelper.notEquals(Type_LongPrimitive Col1, Type_LongPrimitive Col2)
QueryHelper	QueryHelper.notEquals(Type_ShortPrimitive Col, short V)
QueryHelper	QueryHelper.notEquals(Type_ShortPrimitive Col, java.lang.Short coalesceVal, short V)
QueryHelper	QueryHelper.notEquals(Type_ShortPrimitive Col1, Type_ShortPrimitive Col2)
QueryHelper	QueryHelper.notEquals(Type_StringPrimitive Col, java.lang.String V)
QueryHelper	QueryHelper.notEquals(Type_StringPrimitive Col, java.lang.String coalesceVal, java.lang.String V)
QueryHelper	QueryHelper.notEquals(Type_StringPrimitive Col1, Type_StringPrimitive Col2)
QueryHelper	QueryHelper.notExists(SelectQuery subQ)
QueryHelper	QueryHelper.openPar()
QueryHelper	QueryHelper.or()
QueryHelper	QueryHelper.orderBy(ColumnDefinition Col, boolean Asc)
QueryHelper	QueryHelper.orderBy(ColumnDefinition Col, boolean Asc, boolean NullsLast)
QueryHelper	QueryHelper.orderByCountStar(boolean Asc)
QueryHelper	QueryHelper.padding(int spaces)
QueryHelper	QueryHelper.plus(boolean V)
QueryHelper	QueryHelper.plus(char V)
QueryHelper	QueryHelper.plus(double V)
QueryHelper	QueryHelper.plus(float V)
QueryHelper	QueryHelper.plus(int V)
QueryHelper	QueryHelper.plus(long V)
QueryHelper	QueryHelper.plus(java.lang.String V)
QueryHelper	QueryHelper.plus(java.time.LocalDate LDT)
QueryHelper	QueryHelper.plus(java.time.ZonedDateTime ZDT)
QueryHelper	QueryHelper.plus(ColumnDefinition Col)
QueryHelper	QueryHelper.selectCase(QueryHelper.CaseClause clause, java.lang.String elseValue, java.lang.String aliasName)
QueryHelper	QueryHelper.selectColumn(int TableId, java.lang.String ColumnName, AggregateType Agg, java.lang.String AliasName)
QueryHelper	QueryHelper.selectColumn(ColumnDefinition Col)
QueryHelper	QueryHelper.selectColumn(ColumnDefinition Col, AggregateType Agg, java.lang.String Alias)
protected QueryHelper	QueryHelper.selectColumnBase(java.lang.String ColStr)
QueryHelper	QueryHelper.selectCountDistinct(ColumnDefinition Col)
QueryHelper	QueryHelper.selectCountStar()
QueryHelper	QueryHelper.selectDistinctColumn(ColumnDefinition Col)
QueryHelper	QueryHelper.set(Type_BooleanPrimitive Col1, boolean V)
QueryHelper	QueryHelper.set(Type_BooleanPrimitive Col1, Type_BooleanPrimitive Col2)
QueryHelper	QueryHelper.set(Type_CharPrimitive Col1, char V)
QueryHelper	QueryHelper.set(Type_CharPrimitive Col1, Type_CharPrimitive Col2)
QueryHelper	QueryHelper.set(Type_DatetimePrimitive Col1, java.time.ZonedDateTime V)
QueryHelper	QueryHelper.set(Type_DatetimePrimitive Col1, Type_DatetimePrimitive Col2)
QueryHelper	QueryHelper.set(Type_DoublePrimitive Col1, double V)
QueryHelper	QueryHelper.set(Type_DoublePrimitive Col1, Type_DoublePrimitive Col2)
QueryHelper	QueryHelper.set(Type_FloatPrimitive Col1, float V)
QueryHelper	QueryHelper.set(Type_FloatPrimitive Col1, Type_FloatPrimitive Col2)
QueryHelper	QueryHelper.set(Type_IntegerPrimitive Col1, int V)
QueryHelper	QueryHelper.set(Type_IntegerPrimitive Col1, Type_IntegerPrimitive Col2)
QueryHelper	QueryHelper.set(Type_IntegerPrimitive Col1, Type_ShortPrimitive Col2)
QueryHelper	QueryHelper.set(Type_LongPrimitive Col1, long V)
QueryHelper	QueryHelper.set(Type_LongPrimitive Col1, Type_IntegerPrimitive Col2)
QueryHelper	QueryHelper.set(Type_LongPrimitive Col1, Type_LongPrimitive Col2)
QueryHelper	QueryHelper.set(Type_LongPrimitive Col1, Type_ShortPrimitive Col2)
QueryHelper	QueryHelper.set(Type_ShortPrimitive Col1, short V)
QueryHelper	QueryHelper.set(Type_ShortPrimitive Col1, Type_ShortPrimitive Col2)
QueryHelper	QueryHelper.set(Type_StringPrimitive Col1, java.lang.String V)
QueryHelper	QueryHelper.set(Type_StringPrimitive Col1, Type_StringPrimitive Col2)
QueryHelper	QueryHelper.setNow(Type_DatetimePrimitive Col1)
QueryHelper	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	QueryHelper.subWhere(QueryHelper.CaseClause clause)
QueryHelper	QueryHelper.subWhere(SelectQuery subWhere)
QueryHelper	QueryHelper.tableSample(float Percentage, boolean Repeatable)
QueryHelper	QueryHelper.values()
QueryHelper	QueryHelper.where()
QueryHelper	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).