sql
command which will accept any sort of data as JSON, marshal it into a query object and allow you to alias, filter, order, and limit the rows on the fly using CFML's query of queries.data
- The JSON to processselect
- A SQL list of column names, eg. "name,version"where
- A SQL where filter used in a query of queries, eg. "name like '%My%'"orderby
- A SQL order by used in a query of queries, eg. "name asc, version desc"limit
- A SQL limit/offset used in a query of queries, eg. "5" or "5,10" (eg. offset 5 limit 10)headerNames
- An list of column headers to use (used for array of arrays)headerNames
, the columns will be named col_1
, col_2
, col_3
, etc...sql
command works very nicely with the tablePrinter
command.