packages/docs/connections/KnexRequests.md
Request types:
query: object[]: Required - SQL query builder array. An array of objects, with a single key which is the name of the knex builder function. The value should be an array of arguments to pass to the builder function.tableName: string | object: The name of the table to query from.id: knexBuilder
type: KnexBuilder
connectionId: knex
payload:
name:
_state: name
properties:
query:
- select:
- '*'
- from:
- users
- where:
- name
- _payload: name
tableName:id: knexBuilder
type: KnexBuilder
connectionId: knex
payload:
name:
_state: name
properties:
tableName: users
query:
- select:
- '*'
- where:
- name
- _payload: name
id: knexBuilder
type: KnexBuilder
connectionId: knex
properties:
tableName:
a: tableA
b: tableB
query:
- select:
- aField: 'a.field'
- bField: 'b.field'
- limit:
- 1
query: string: Required - SQL query string.parameters: string | number | array | object: SQL query parameters.id: knexRaw
type: KnexRaw
connectionId: knex
properties:
query: SELECT * FROM "my_table";
id: knexRaw
type: KnexRaw
connectionId: knex
payload:
selected_name:
_state: selected_name
properties:
query: select * from users where name = :name
parameters:
name:
_payload: selected_name
id: knexRaw
type: KnexRaw
connectionId: knex
payload:
selected_name:
_state: selected_name
properties:
query: select * from users where name = ?
parameters:
- _payload: selected_name
.sql file:id: knexRaw
type: KnexRaw
connectionId: knex
properties:
query:
_ref: my_query.sql