Class SQLFragment

constructor

• new SQLFragment(sql: string, bindings: readonly SQLBinding[]): SQLFragment

  Parameters

  • sql: string
  • bindings: readonly SQLBinding[]

  Returns SQLFragment

Readonlybindings

Readonlysql

toDebugString

• get toDebugString(): string

  Get a debug representation of the query with values inline WARNING: This is for debugging only. Never execute the returned string directly.

  Returns string

append

• append(other: SQLFragment): SQLFragment

  Combine SQL fragments

  Parameters

  • other: SQLFragment

  Returns SQLFragment

getKnexBindings

• getKnexBindings(): readonly SupportedSQLValue[]

  Get bindings in the format expected by Knex. Knex expects a flat array where both identifiers and values are mixed in order.

  Returns readonly SupportedSQLValue[]

Staticconcat

• concat(...fragments: SQLFragment[]): SQLFragment

  Concatenate multiple SQL fragments with space separator. Useful for combining SQL clauses like WHERE, ORDER BY, etc.

  Parameters

  • ...fragments: SQLFragment[]

  Returns SQLFragment

  Example

  const where = sql`WHERE age > ${18}`;
  const orderBy = sql`ORDER BY name`;
  const query = SQLFragment.concat(sql`SELECT * FROM users`, where, orderBy);
  // Generates: "SELECT * FROM users WHERE age > ? ORDER BY name"
  Copy

Staticjoin

• join(fragments: SQLFragment[], separator?: string): SQLFragment

  Join multiple SQL fragments into a single fragment with a separator.

  Parameters

  • fragments: SQLFragment[]

    Array of SQL fragments to join

  • separator: string = ', '

    Separator string (default: ', ')

  Returns SQLFragment