Uses of Interface
com.gengoai.sql.SQLElement

Packages that use SQLElement

Package	Description
com.gengoai.sql
com.gengoai.sql.constraint
com.gengoai.sql.object
com.gengoai.sql.operator
com.gengoai.sql.sqlite
com.gengoai.sql.statement

Uses of SQLElement in com.gengoai.sql

Subinterfaces of SQLElement in com.gengoai.sql

Modifier and Type	Interface	Description
interface	CompositeSQLElement	An SQLElement that is made up of one more sub elements.
interface	NamedSQLElement	An SQLElement that represents a named object.
interface	PreRenderedSQL	An SQLElement that is already rendered into SQL.

Classes in com.gengoai.sql that implement SQLElement

Modifier and Type	Class	Description
class	SQLFunction	Encapsulates an SQL Function (e.g.

Fields in com.gengoai.sql declared as SQLElement

Modifier and Type	Field	Description
static SQLElement	SQL.ALL	SQLElement representing "*" for selecting ALL
static SQLElement	SQL.INDEXED_ARGUMENT	SQLElement representing "?" of use with PreparedStatements

Methods in com.gengoai.sql that return SQLElement

Modifier and Type	Method	Description
static SQLElement	SQL.namedArgument(@NonNull SQLElement name)	Named argument sql element.
static SQLElement	SQL.nullValue()	Generates a null value
static SQLElement	SQL.sql(@NonNull String... components)	Free form SQL from one or more sql statements

Methods in com.gengoai.sql with parameters of type SQLElement

Modifier and Type	Method	Description
static SQLOperable	SQL.F.abs(@NonNull SQLElement arg)	Generates an SQLOperable representing the absolute value of the given argument.
static SQLOperable	SQL.and(@NonNull SQLElement... elements)	Combines one or more SQLElements via an AND
static SQLOperable	SQL.F.average(@NonNull SQLElement arg)	Generates an SQLOperable representing the average value of the given argument.
static SQLOperable	SQL.F.coalesce(@NonNull SQLElement... args)	Generates an SQLOperable representing the coalesce function which returns the first non-null value.
static SQLOperable	SQL.F.count(@NonNull SQLElement arg)	Generates an SQLOperable representing the count value of the given argument.
static SQLOperable	SQL.F.date(@NonNull SQLElement timeString, @NonNull SQLElement... args)	Generates an SQLOperable representing the date function, which converts the given time string into a date object.
static SQLOperable	SQL.F.date(@NonNull String timeString, @NonNull SQLElement... args)	Generates an SQLOperable representing the date function, which converts the given time string into a date object.
static SQLOperable	SQL.F.dateTime(@NonNull SQLElement timeString, @NonNull SQLElement... args)	Generates an SQLOperable representing the datetime function, which converts the given time string into a date object.
static SQLOperable	SQL.F.dateTime(@NonNull String timeString, @NonNull SQLElement... args)	Generates an SQLOperable representing the datetime function, which converts the given time string into a date object.
static SQLFunction	SQLFunction.function(String name, @NonNull SQLElement arg1, @NonNull SQLElement... args)	Constructs a generic SQLFunction made up of a function name and zero or more arguments.
static SQLOperable	SQL.group(@NonNull SQLElement... elements)	Groups one or more expressions by placing them in parenthesis
static SQLOperable	SQL.F.groupConcat(@NonNull SQLElement arg, @NonNull String delimiter)	Generates an SQLOperable representing the group concat function, which concatenates one more items with a given delimiter.
static SQLOperable	SQL.F.ifNull(@NonNull SQLElement expression, @NonNull SQLElement value)	Generates an SQLOperable representing an "if null" function, which returns the specified value if the expression is null.
static SQLOperable	SQL.F.instr(@NonNull SQLElement string, @NonNull SQLElement substring)	Generates an SQLOperable representing an "in string" function, which searches a string for a substring.
static SQLOperable	SQL.F.instr(@NonNull SQLElement string, @NonNull String substring)	Generates an SQLOperable representing an "in string" function, which searches a string for a substring.
static SQLOperable	SQL.F.json_extract(@NonNull SQLElement json, @NonNull SQLElement jsonPath)	Generates an SQLOperable representing a function to extract a json value (object, array, primitive) from a json column for a given path in the json tree.
static SQLOperable	SQL.F.length(@NonNull SQLElement arg)	Generates an SQLOperable representing the length of the string value represented by the given argument.
static SQLOperable	SQL.F.lower(@NonNull SQLElement arg)	Generates an SQLOperable representing the lower function, which lower cases a string value.
static SQLOperable	SQL.F.ltrim(@NonNull SQLElement arg)	Generates an SQLOperable representing the ltrim function, which trims from the left side of a string.
static SQLOperable	SQL.F.max(@NonNull SQLElement arg)	Generates an SQLOperable representing the max function.
static SQLOperable	SQL.F.min(@NonNull SQLElement arg)	Generates an SQLOperable representing the min function.
<T> int	SQLContext.multiThreadedBatch(@NonNull SQLElement sql, @NonNull Stream<? extends T> items, @NonNull CheckedBiConsumer<T,NamedPreparedStatement> consumer, int batchSize)	Multi threaded batch int.
static SQLElement	SQL.namedArgument(@NonNull SQLElement name)	Named argument sql element.
static SQLOperable	SQL.F.nullIf(@NonNull SQLElement arg1, @NonNull SQLElement arg2)	Generates an SQLOperable representing an "null if" function, which returns null if the two arguments are equal.
static SQLOperable	SQL.or(@NonNull SQLElement... elements)	Combines one or more SQLElements via an OR
static SQLOperable	SQL.F.regexp(@NonNull SQLElement arg1, @NonNull SQLElement arg2)	Generates an SQLOperable representing a regular expression matching operating
static SQLOperable	SQL.F.regexp(@NonNull SQLElement arg1, @NonNull String arg2)	Generates an SQLOperable representing a regular expression matching operating
String	SQLContext.render(@NonNull SQLElement sql)	Render string.
String	SQLDialect.render(@NonNull SQLElement sqlElement)	Render string.
static SQLOperable	SQL.F.replace(@NonNull SQLElement arg, String pattern, String replacement)	Generates an SQLOperable representing an string "replace" function, which replaces a given pattern with a given replacement in string expression.
static SQLOperable	SQL.F.round(@NonNull SQLElement arg, int precision)	Generates an SQLOperable that rounds the given argument to the given precision.
static SQLOperable	SQL.F.rtrim(@NonNull SQLElement arg)	Generates an SQLOperable representing the right function, which trims from the right side of a string.
static SQLOperable	SQL.F.strftime(@NonNull SQLElement format, @NonNull SQLElement timeString, @NonNull SQLElement... args)	Generates an SQLOperable representing a function to format times as strings.
static SQLOperable	SQL.F.substr(@NonNull SQLElement arg, int start, int length)	Generates an SQLOperable representing an "substring" function, which returns a substring from the given starting position and of the given length from an argument.
static SQLOperable	SQL.F.substr(@NonNull SQLElement arg, @NonNull SQLElement start, @NonNull SQLElement length)	Generates an SQLOperable representing an "substring" function, which returns a substring from the given starting position and of the given length from an argument.
static SQLOperable	SQL.F.substr(@NonNull String column, @NonNull SQLElement start, @NonNull SQLElement length)	Generates an SQLOperable representing an "substring" function, which returns a substring from the given starting position and of the given length from an argument.
static SQLOperable	SQL.F.sum(@NonNull SQLElement arg)	Generates an SQLOperable representing the sum function.
static Table	SQL.table(String name, SQLElement type, @NonNull Consumer<SQL.TableDef> definition)
static SQLOperable	SQL.F.time(@NonNull SQLOperable timeString, @NonNull SQLElement... args)	Generates an SQLOperable representing the datetime function, which converts the given time string into a date object.
static SQLOperable	SQL.F.time(@NonNull String timeString, @NonNull SQLElement... args)	Generates an SQLOperable representing the time function, which converts the given time string into a date object.
static SQLOperable	SQL.F.trim(@NonNull SQLElement arg)	Generates an SQLOperable representing the trim function, which trims from the right and left side of a string.
static SQLOperable	SQL.F.upper(@NonNull SQLElement arg)	Generates an SQLOperable representing the lower function, which lower cases a string value.

Method parameters in com.gengoai.sql with type arguments of type SQLElement

Modifier and Type	Method	Description
static SQLFunction	SQLFunction.function(String name, @NonNull List<SQLElement> args)
static SQLOperable	SQL.F.groupConcat(@NonNull Collection<? extends SQLElement> args, @NonNull String delimiter)	Generates an SQLOperable representing the group concat function, which concatenates one more items with a given delimiter.
protected String	SQLDialect.join(@NonNull String delimiter, @NonNull Collection<? extends SQLElement> items)	Joins one or more SQLElement as SQL with the given delimiter

Uses of SQLElement in com.gengoai.sql.constraint

Classes in com.gengoai.sql.constraint that implement SQLElement

Modifier and Type	Class	Description
class	ConflictClause
class	Deferrable
class	ForeignKeyAction

Fields in com.gengoai.sql.constraint declared as SQLElement

Modifier and Type	Field	Description
protected SQLElement	ForeignKeyConstraint.foreignTable

Fields in com.gengoai.sql.constraint with type parameters of type SQLElement

Modifier and Type	Field	Description
protected List<SQLElement>	ForeignKeyConstraint.columns
protected List<SQLElement>	ForeignKeyConstraint.foreignTableColumns

Methods in com.gengoai.sql.constraint that return types with arguments of type SQLElement

Modifier and Type	Method	Description
List<SQLElement>	ForeignKeyConstraint.getColumns()
List<SQLElement>	ForeignKeyConstraint.getForeignTableColumns()

Methods in com.gengoai.sql.constraint with parameters of type SQLElement

Modifier and Type	Method	Description
default CheckConstraint	ConstraintBuilder.check(@NonNull SQLElement sql)
default ForeignKeyConstraint	ConstraintBuilder.foreignKey(@NonNull Collection<String> columns, @NonNull SQLElement foreignTable, @NonNull Collection<String> foreignTableColumns)
default ForeignKeyConstraint	ConstraintBuilder.foreignKey(@NonNull List<SQLElement> columns, @NonNull SQLElement foreignTable, @NonNull List<SQLElement> foreignTableColumns)
default NotNullConstraint	ConstraintBuilder.notNull(@NonNull SQLElement column)
default PrimaryKeyConstraint	ConstraintBuilder.primaryKey(@NonNull SQLElement... columns)
default UniqueConstraint	ConstraintBuilder.unique(@NonNull SQLElement... columns)

Method parameters in com.gengoai.sql.constraint with type arguments of type SQLElement

Modifier and Type	Method	Description
default ForeignKeyConstraint	ConstraintBuilder.foreignKey(@NonNull List<SQLElement> columns, @NonNull SQLElement foreignTable, @NonNull List<SQLElement> foreignTableColumns)
default ForeignKeyConstraint	ConstraintBuilder.foreignKey(@NonNull List<SQLElement> columns, @NonNull String foreignTable, @NonNull List<SQLElement> foreignTableColumns)
default PrimaryKeyConstraint	ConstraintBuilder.primaryKey(Collection<SQLElement> columns)
default UniqueConstraint	ConstraintBuilder.unique(Collection<SQLElement> columns)

Constructors in com.gengoai.sql.constraint with parameters of type SQLElement

Constructor	Description
CheckConstraint(String name, @NonNull SQLElement expression)
ForeignKeyConstraint(String name, @NonNull Collection<SQLElement> columns, @NonNull SQLElement foreignTable, @NonNull Collection<SQLElement> foreignTableColumns)
NotNullConstraint(String name, @NonNull SQLElement column)

Constructor parameters in com.gengoai.sql.constraint with type arguments of type SQLElement

Constructor	Description
ForeignKeyConstraint(String name, @NonNull Collection<SQLElement> columns, @NonNull SQLElement foreignTable, @NonNull Collection<SQLElement> foreignTableColumns)
PrimaryKeyConstraint(String name, @NonNull Collection<SQLElement> columns)
UniqueConstraint(String name, @NonNull Collection<SQLElement> columns)

Uses of SQLElement in com.gengoai.sql.object

Classes in com.gengoai.sql.object that implement SQLElement

Modifier and Type	Class	Description
class	Column	Represents a column in a database table.
class	Index	Represents an index on one or more columns in a table.
class	SQLDMLOperation	Enumeration of data manipulation statements in SQL.
class	SQLObject	Base class for SQL objects, e.g.
class	Table	The type Table.
class	Trigger	Defines an SQL Trigger
class	TriggerTime	When a trigger is fired

Methods in com.gengoai.sql.object with parameters of type SQLElement

Modifier and Type	Method	Description
Column	Column.asStored(SQLElement element)	Sets a value that is auto generated for the column on insertion time and is stored in the database.
Column	Column.asVirtual(SQLElement element)	Sets a value that is auto generated for the column on query time and not stored in the database.
Column	Column.check(@NonNull SQLElement element)	Adds a Check constraint on this column.
Column	Column.check(String name, @NonNull SQLElement element)	Adds a Check constraint with the given name on this column.
Column	Column.defaultValue(SQLElement defaultValue)	Sets the default value to be assigned to the column when no value is given on an insert.
int	Table.delete(@NonNull SQLContext context, @NonNull SQLElement where)	Deletes all rows matching the given where criteria
static IndexBuilder	Index.index(String name, @NonNull SQLElement table)
Index	IndexBuilder.nonUnique(@NonNull SQLElement... columns)
Select	Table.select(@NonNull SQLElement... columns)	Creates a select statement selecting from this table returning the specified columns
Index	IndexBuilder.unique(@NonNull SQLElement... columns)
int	Table.update(@NonNull SQLContext context, @NonNull UpdateType updateType, @NonNull Map<String,SQLElement> setParameters, @NonNull SQLElement where)
int	Table.update(@NonNull SQLContext context, @NonNull Map<String,SQLElement> setParameters, @NonNull SQLElement where)

Method parameters in com.gengoai.sql.object with type arguments of type SQLElement

Modifier and Type	Method	Description
Index	IndexBuilder.nonUnique(@NonNull List<SQLElement> columns)
Index	IndexBuilder.unique(@NonNull List<SQLElement> columns)
int	Table.update(@NonNull SQLContext context, @NonNull UpdateType updateType, @NonNull Map<String,SQLElement> setParameters, @NonNull SQLElement where)
int	Table.update(@NonNull SQLContext context, @NonNull Map<String,SQLElement> setParameters, @NonNull SQLElement where)

Constructors in com.gengoai.sql.object with parameters of type SQLElement

Constructor	Description
Index(@NonNull SQLElement table, String name, boolean isUnique, @NonNull List<SQLElement> columns)	Instantiates a new Index.
Table(String name, SQLElement tableType)	Instantiates a new Table.
Table(String name, SQLElement tableType, @NonNull List<Column> columns, @NonNull List<Constraint> constraints)	Instantiates a new Table.

Constructor parameters in com.gengoai.sql.object with type arguments of type SQLElement

Constructor	Description
Index(@NonNull Table table, @NonNull List<SQLElement> columns)	Instantiates a new Index.
Index(@NonNull SQLElement table, String name, boolean isUnique, @NonNull List<SQLElement> columns)	Instantiates a new Index.

Uses of SQLElement in com.gengoai.sql.operator

Subinterfaces of SQLElement in com.gengoai.sql.operator

Modifier and Type	Interface	Description
interface	SQLOperable	Interface defining an SQLElement that is can be an argument to an SQLOperator.

Classes in com.gengoai.sql.operator that implement SQLElement

Modifier and Type	Class	Description
class	Between	Specialized operator for SQL Between operators
class	InfixBinaryOperator	Specialized operator for binary infix operators
class	PostfixUnaryOperator	Unary Postfix SQLOperator
class	PrefixUnaryOperator	Unary Prefix SQLOperator
class	QueryOperator	A SQLOperator which works on QueryStatements and result is also an QueryStatement
class	SQLOperator	Defines an SQL operator that operators over one or more SQLElement

Methods in com.gengoai.sql.operator with parameters of type SQLElement

Modifier and Type	Method	Description
default SQLOperable	SQLOperable.add(@NonNull SQLElement rhs)	Adds this element with the given element.
default SQLOperable	SQLOperable.and(@NonNull SQLElement rhs)	Ands this element with given element.
default SQLOperable	SQLOperable.between(@NonNull SQLElement lower, @NonNull SQLElement upper)	Creates a BETWEEN operator with this element representing the column name
default SQLOperable	SQLOperable.concat(@NonNull SQLElement rhs)	Concatenates this element with the given element
default SQLOperable	SQLOperable.div(@NonNull SQLElement rhs)	Divides this element by the given element.
default SQLOperable	SQLOperable.eq(@NonNull SQLElement rhs)	Creates an equality check between this element and the given element
default SQLOperable	SQLOperable.gt(@NonNull SQLElement rhs)	Creates a greater than equality check between this element and the given element
default SQLOperable	SQLOperable.gte(@NonNull SQLElement rhs)	Creates a greater than equal to equality check between this element and the given element
default SQLOperable	SQLOperable.in(@NonNull SQLElement element)	Creates an IN operator treating this element as the item being checked and the given element as the list of items being checked in.
default SQLOperable	SQLOperable.like(@NonNull SQLElement rhs)	Creates a LIKE operator with this element as the column or expression being checked .
default SQLOperable	SQLOperable.lt(@NonNull SQLElement rhs)	Creates a less than equality check between this element and the given element
default SQLOperable	SQLOperable.lte(@NonNull SQLElement rhs)	Creates a less than or equal to equality check between this element and the given element
default SQLOperable	SQLOperable.mod(@NonNull SQLElement rhs)	Creates an SQLOperable that is the result of taking mode rhs of this number.
default SQLOperable	SQLOperable.mul(@NonNull SQLElement rhs)	Multiplies this element with the given element.
default SQLOperable	SQLOperable.neq(@NonNull SQLElement rhs)	Creates an inequality check between this element and the given element
default SQLOperable	SQLOperable.or(@NonNull SQLElement rhs)	ORs this element with given element.
default SQLOperable	SQLOperable.pow(@NonNull SQLElement rhs)	Creates an SQLOperable that is the result of raising this number to the power of rhs.
default SQLOperable	SQLOperable.sub(@NonNull SQLElement rhs)	Subtracts the given element from this element with.

Constructors in com.gengoai.sql.operator with parameters of type SQLElement

Constructor	Description
Between(@NonNull SQLElement column, @NonNull SQLElement lower, @NonNull SQLElement higher)
InfixBinaryOperator(String operator, @NonNull SQLElement arg1, @NonNull SQLElement arg2)	Instantiates a new SQLBinaryOperator.
PostfixUnaryOperator(String operator, @NonNull SQLElement arg1, boolean requiresParenthesis)	Instantiates a new SQLPostfixUnaryOperator.
PrefixUnaryOperator(String operator, @NonNull SQLElement arg1, boolean requiresParenthesis)	Instantiates a new SQLPrefixUnaryOperator.

Uses of SQLElement in com.gengoai.sql.sqlite

Classes in com.gengoai.sql.sqlite that implement SQLElement

Modifier and Type	Class	Description
class	SQLiteFullTextTable	The type Sq lite full text table.

Methods in com.gengoai.sql.sqlite with parameters of type SQLElement

Modifier and Type	Method	Description
Delete	SQLiteFullTextTable.delete(SQLElement where)	Creates a delete statement that will delete all rows matching the given where criteria
Select	SQLiteFullTextTable.select(@NonNull SQLElement... columns)	Creates a select statement selecting from this table returning the specified columns

Uses of SQLElement in com.gengoai.sql.statement

Subinterfaces of SQLElement in com.gengoai.sql.statement

Modifier and Type	Interface	Description
interface	AlterTableAction	Actions that can be performed when altering a table.
interface	UpdateStatement	SQL Statement that updates / modifies the database.

Classes in com.gengoai.sql.statement that implement SQLElement

Modifier and Type	Class	Description
class	AlterTable	Defines an SQL Alter Table statement to alter the definition of a table.
static class	AlterTableAction.AddColumn	Adds a column
static class	AlterTableAction.AlterColumn	Alters a column definition
static class	AlterTableAction.DropColumn	Drops a column
static class	AlterTableAction.RenameColumn	Renames a column
static class	AlterTableAction.RenameTable	Renames the table
class	Create	SQL create statement for SQL objects (Table, Index, Trigger, etc).
class	Delete	SQL DELETE statement for delete rows from a table.
class	Drop	SQL Drop statement for SQL Objects (Table, Index, Trigger, etc)
class	Insert	SQL Insert Statement
class	Join	SQL element defining a Join statement during selection.
class	JoinType	Type of Join
class	QueryStatement	SQL Statement that performs a query over a database.
class	Select	SQL statement for selecting data from a table
class	Update	SQL Update statement
class	UpsertAction	The action to perform for doing an upsert as part of index conflict in an Insert statement.
class	UpsertClause	Defines an upsert clause when there is a key conflict on an Insert statement

Methods in com.gengoai.sql.statement with parameters of type SQLElement

Modifier and Type	Method	Description
Insert	Insert.columns(@NonNull SQLElement... columns)	Set the named columns being inserted (note that calling this removed previously specified columns).
Select	Select.columns(@NonNull SQLElement... columns)	Sets the columns being selected.
static Delete	Delete.from(@NonNull SQLElement table)	Creates a Delete statement to delete from the given table
static Select	Select.from(@NonNull SQLElement table)	Creates a new Select statement with the given table for the from clause
Select	Select.groupBy(@NonNull SQLElement... groupBy)	Sets the group by clause to the given strings.
Select	Select.having(SQLElement havingClause)	Sets the criteria for group bys (i.e.
UpsertClause	UpsertClause.indexedColumns(@NonNull SQLElement... columns)	Sets the columns that specifies the keys (indexed columns) for the upsert
UpsertClause	UpsertClause.indexedWhere(SQLElement whereClause)	Sets the criteria (i.e.
Select	Select.innerJoin(@NonNull SQLElement table, @NonNull SQLElement criteria)	Adds an inner join with the given table on the given criteria to the from clause
static Insert	Insert.into(@NonNull SQLElement table)	Create an Insert statement that will insert into the given SQLElement.
Select	Select.join(@NonNull JoinType type, @NonNull SQLElement table, @NonNull SQLElement criteria)	Adds a join with the given table on the given criteria to the from clause
Select	Select.leftOuterJoin(@NonNull SQLElement table, @NonNull SQLElement criteria)	Adds a left outer join with the given table on the given criteria to the from clause
Select	Select.limit(SQLElement limitClause)	Sets the limit clause for selection
Select	Select.orderBy(@NonNull SQLElement... orderBy)	Sets the order by clause to the given strings.
Select	Select.rightOuterJoin(@NonNull SQLElement table, @NonNull SQLElement criteria)	Adds a right outer join with the given table on the given criteria to the from clause
Update	Update.set(@NonNull SQLElement column, @NonNull SQLElement value)	Adds a set parameter to the update defined as a column and value.
Update	Update.set(@NonNull String column, @NonNull SQLElement value)	Adds a set parameter to the update defined as a column and value.
UpsertClause	UpsertClause.set(@NonNull SQLElement column, @NonNull SQLElement value)	Adds a set parameter to the update defined as a column and value.
UpsertClause	UpsertClause.set(@NonNull String column, @NonNull SQLElement value)	Adds a set parameter to the update defined as a column and value.
Update	Update.setIndexedParameter(@NonNull SQLElement column)	Adds a set parameter for the given column and using an indexed parameter value for use in PreparedStatement
UpsertClause	UpsertClause.setIndexedParameter(@NonNull SQLElement column)	Adds a set parameter for the given column and using an indexed parameter value for use in PreparedStatement
Update	Update.setNamedParameter(@NonNull SQLElement column)	Adds a set parameter for the given column and using a named parameter value for use in NamedPreparedStatement
UpsertClause	UpsertClause.setNamedParameter(@NonNull SQLElement column)	Adds a set parameter for the given column and using a named parameter value for use in NamedPreparedStatement
static AlterTable	AlterTable.table(@NonNull SQLElement table)	Static method for constructing an AlterTable statement given the table being altered.
static Update	Update.table(@NonNull SQLElement table)	Creates a new Update statement which will update the given table
UpsertClause	UpsertClause.updateWhere(SQLElement whereClause)	Sets the criteria (i.e.
static UpsertClause	UpsertClause.upsert(@NonNull SQLElement... columns)	Creates a new Upsert clause with given columns as the keys (indexed columns)
Insert	Insert.values(@NonNull SQLElement... values)	Sets the values to be inserted (note that this will remove any previously set values or select statement).
Delete	Delete.where(SQLElement whereClause)	Sets the criteria (i.e.
Select	Select.where(SQLElement whereClause)	Sets the criteria (i.e.
Update	Update.where(SQLElement whereClause)	Sets the criteria (i.e.
Select	Select.window(SQLElement window)	Sets the Window function for the selection.

Method parameters in com.gengoai.sql.statement with type arguments of type SQLElement

Modifier and Type	Method	Description
Insert	Insert.columns(@NonNull Collection<? extends SQLElement> columns)	Set the named columns being inserted (note that calling this removed previously specified columns).
Select	Select.columns(@NonNull Collection<? extends SQLElement> columns)	Sets the columns being selected.
Select	Select.groupBy(@NonNull Collection<? extends SQLElement> groupBy)	Sets the group by clause to the given strings.
UpsertClause	UpsertClause.indexedColumns(@NonNull Collection<? extends SQLElement> columns)	Sets the columns that specifies the keys (indexed columns) for the upsert
Select	Select.orderBy(@NonNull Collection<? extends SQLElement> orderBy)	Sets the order by clause to the given strings.
Insert	Insert.values(@NonNull Collection<? extends SQLElement> values)	Sets the values to be inserted (note that this will remove any previously set values or select statement).