Return new query based on the provided column list, column types, and/or row data.
Available column types are:
bigint
binary
bit
date
decimal
double
integer
null
object
other
time
timestamp
varchar
If columnTypeList is empty, all columns will be of type "object".
Last updated
| Argument | Type | Required | Description | Default |
|---|---|---|---|---|
columnList
any
true
The column list to be used in the query, Ex: "name, age, dob". It can also be an array of structs that will be used as the row data.
columnTypeList
string
false
Comma-delimited list specifying column data types. If empty, all columns will be of type "object". Ex: "varchar, integer, date"
rowData
any
false
Data to populate the query. Can be a struct (with keys matching column names), an array of structs, or an array of arrays (in same order as columnList). Ex: [{name: "John", age: 30}, {name: "Jane", age: 25}]
