Class SQLiteSelectBuilder<TSelection, TResultType, TRunResult, TBuilderMode>

constructor

• new SQLiteSelectBuilder<
      TSelection extends SelectedFields
      | undefined,
      TResultType extends "sync" | "async",
      TRunResult,
      TBuilderMode extends "db" | "qb" = "db",
  >(
      config: {
          dialect: SQLiteDialect;
          distinct?: boolean;
          fields: TSelection;
          session: SQLiteSession<any, any, any, any> | undefined;
          withList?: Subquery<string, Record<string, unknown>>[];
      },
  ): SQLiteSelectBuilder<TSelection, TResultType, TRunResult, TBuilderMode>

  Type Parameters

  • TSelection extends SelectedFields | undefined
  • TResultType extends "sync" | "async"
  • TRunResult
  • TBuilderMode extends "db" | "qb" = "db"

  Parameters

  • config: {
        dialect: SQLiteDialect;
        distinct?: boolean;
        fields: TSelection;
        session: SQLiteSession<any, any, any, any> | undefined;
        withList?: Subquery<string, Record<string, unknown>>[];
    }

  Returns SQLiteSelectBuilder<TSelection, TResultType, TRunResult, TBuilderMode>

Static Readonly[entityKind]

from

• from<
      TFrom extends
          | SQLiteTable<TableConfig>
          | SQLiteViewBase<string, boolean, ColumnsSelection>
          | SQL<unknown>
          | Subquery<string, Record<string, unknown>>,
  >(
      source: TFrom,
  ): CreateSQLiteSelectFromBuilderMode<
      TBuilderMode,
      GetSelectTableName<TFrom>,
      TResultType,
      TRunResult,
      TSelection extends undefined ? GetSelectTableSelection<TFrom> : TSelection,
      TSelection extends undefined ? "single" : "partial",
  >

  Type Parameters

  • TFrom extends
        | SQLiteTable<TableConfig>
        | SQLiteViewBase<string, boolean, ColumnsSelection>
        | SQL<unknown>
        | Subquery<string, Record<string, unknown>>

  Parameters

  • source: TFrom

  Returns CreateSQLiteSelectFromBuilderMode<
      TBuilderMode,
      GetSelectTableName<TFrom>,
      TResultType,
      TRunResult,
      TSelection extends undefined ? GetSelectTableSelection<TFrom> : TSelection,
      TSelection extends undefined ? "single" : "partial",
  >