Class QueryBuilder

constructor

• new QueryBuilder(dialect?: SQLiteDialect | SQLiteDialectConfig): QueryBuilder

  Parameters

  • Optionaldialect: SQLiteDialect | SQLiteDialectConfig

  Returns QueryBuilder

$with

Static Readonly[entityKind]

select

• select(): SQLiteSelectBuilder<undefined, "sync", void, "qb">

  Returns SQLiteSelectBuilder<undefined, "sync", void, "qb">

• select<TSelection extends SelectedFields>(
      fields: TSelection,
  ): SQLiteSelectBuilder<TSelection, "sync", void, "qb">

  Type Parameters

  • TSelection extends SelectedFields

  Parameters

  • fields: TSelection

  Returns SQLiteSelectBuilder<TSelection, "sync", void, "qb">

selectDistinct

• selectDistinct(): SQLiteSelectBuilder<undefined, "sync", void, "qb">

  Returns SQLiteSelectBuilder<undefined, "sync", void, "qb">

• selectDistinct<TSelection extends SelectedFields>(
      fields: TSelection,
  ): SQLiteSelectBuilder<TSelection, "sync", void, "qb">

  Type Parameters

  • TSelection extends SelectedFields

  Parameters

  • fields: TSelection

  Returns SQLiteSelectBuilder<TSelection, "sync", void, "qb">

with

• with(
      ...queries: WithSubquery<string, Record<string, unknown>>[],
  ): {
      select: {
          (): SQLiteSelectBuilder<undefined, "sync", void, "qb">;
          <TSelection extends SelectedFields>(
              fields: TSelection,
          ): SQLiteSelectBuilder<TSelection, "sync", void, "qb">;
      };
      selectDistinct: {
          (): SQLiteSelectBuilder<undefined, "sync", void, "qb">;
          <TSelection extends SelectedFields>(
              fields: TSelection,
          ): SQLiteSelectBuilder<TSelection, "sync", void, "qb">;
      };
  }

  Parameters

  • ...queries: WithSubquery<string, Record<string, unknown>>[]

  Returns {
      select: {
          (): SQLiteSelectBuilder<undefined, "sync", void, "qb">;
          <TSelection extends SelectedFields>(
              fields: TSelection,
          ): SQLiteSelectBuilder<TSelection, "sync", void, "qb">;
      };
      selectDistinct: {
          (): SQLiteSelectBuilder<undefined, "sync", void, "qb">;
          <TSelection extends SelectedFields>(
              fields: TSelection,
          ): SQLiteSelectBuilder<TSelection, "sync", void, "qb">;
      };
  }