Function rawQuery

rawQuery<S extends ReadObject>(
    knex: Knex,
    output: S,
    queryOrSql: string | QueryBuilder<any, any>,
    bindings?: readonly RawBinding[],
): Promise<InferType<S>[]>
Execute a captured raw SELECT with an explicit complete output schema. SQL must alias columns to the output property names. Each driver row is parsed exactly once; there is no implicit column mapping or entity decoding. Cast exact numeric values to text in SQL before a driver can lose their precision.
Type Parameters
- S extends ReadObject
Parameters
- knex: Knex
  Connection or transaction used for execution.
- output: S
  Synchronous Framework object schema describing every returned row.
- queryOrSql: string | QueryBuilder<any, any>
  Trusted SELECT SQL or an independently captured Knex SELECT.
- bindings: readonly RawBinding[] = []
  Bound values for the trusted SQL string.
Returns Promise<InferType<S>[]>
Parsed rows, never attached to an ORM identity map.
Example
```
const totals = await rawQuery(knex, object({ total: string() }),
    'select sum(amount)::text as total from invoices where owner_id = ?', [ownerId]);
```
- Defined in libs/knex-schema/src/raw.ts:24