sqlCol

swordfish.function.sqlCol()

Generate metacode for selecting one or multiple columns with or without calculations. It is generally used together with function sql and eval to generate SQL statements dynamically.

Parameters:

• colName (Constant) – A string scalar/vector indicating column name(s).

• func (Constant, optional) – A unary function, by default DFLT.

• alias (Constant, optional) – A string scalar/vector indicating column name(s) of the selected column(s) or calculation result(s), by default DFLT.

• qualifier (Constant, optional) – A STRING scalar, by default DFLT. It is only used in a table join operation when we need to select a column that appears in both tables and that is not a matching column. It indicates the table from which to select the column.