Class Sql

constructor

• new Sql(Platform: DatabasePlatform, Source: RowSource): Sql

  Parameters

  • Platform: DatabasePlatform
  • Source: RowSource

  Returns Sql

ReadonlyPlatform

ReadonlySource

AllColumns

• AllColumns(alias: string): string

  The physical columns of the source, comma-separated, read through alias.

  Parameters

  • alias: string

  Returns string

Base

• Base(alias: string): string

  The source's base predicate, read through alias.

  Parameters

  • alias: string

  Returns string

LimitSuffix

• LimitSuffix(n: number): string

  LIMIT n on PostgreSQL, nothing on SQL Server.

  Parameters

  • n: number

  Returns string

Literal

• Literal(value: string): string

  A string literal: N'…' on SQL Server, '…' on PostgreSQL, quotes doubled.

  Parameters

  • value: string

  Returns string

N

• N(value: number): number

  A score threshold on this source's scale.

  Parameters

  • value: number

  Returns number

Text

• Text(sql: string): string

  Final SQL for the platform: {alias.Logical} tokens become alias.[Physical] (a column the source lacks is an error), then brackets become double quotes on PostgreSQL outside strings.

  Parameters

  • sql: string

  Returns string

TopPrefix

• TopPrefix(n: number): string

  SELECT TOP n on SQL Server, nothing on PostgreSQL (see LimitSuffix).

  Parameters

  • n: number

  Returns string

WithRecursive

• WithRecursive(): string

  WITH or WITH RECURSIVE, as the platform needs for a recursive CTE.

  Returns string