Class SqliteQueryBuilder

new SqliteQueryBuilder(
    connection: Database,
    selectedColumns: SelectColumns,
): SqliteQueryBuilder

with(
    name: string,
    query: string | SqliteQueryBuilder,
    options?: {
        columns?: string[];
        params?: QueryValue[];
        recursive?: boolean;
    },
): this

withRecursive(
    name: string,
    query: string | SqliteQueryBuilder,
    options?: { columns?: string[]; params?: QueryValue[] },
): this

from(table: string, alias?: string): this

fromSubquery(
    query: string | SqliteQueryBuilder,
    alias: string,
    params?: QueryValue[],
): this

union(query: string | SqliteQueryBuilder, params?: QueryValue[]): this

unionAll(query: string | SqliteQueryBuilder, params?: QueryValue[]): this

intersect(query: string | SqliteQueryBuilder, params?: QueryValue[]): this

except(query: string | SqliteQueryBuilder, params?: QueryValue[]): this

joinSubquery(
    query: string | SqliteQueryBuilder,
    alias: string,
    onCondition: string,
    options?: Omit<JoinOptions, "alias">,
): this

leftJoinSubquery(
    query: string | SqliteQueryBuilder,
    alias: string,
    onCondition: string,
    options?: Omit<JoinOptions, "alias">,
): this

crossJoinSubquery(
    query: string | SqliteQueryBuilder,
    alias: string,
    options?: Omit<JoinOptions, "alias" | "type">,
): this

join(table: string, onCondition: string, options?: JoinOptions): this

leftJoin(
    table: string,
    onCondition: string,
    options?: Omit<JoinOptions, "type">,
): this

crossJoin(table: string, options?: Omit<JoinOptions, "type">): this

window(name: string, definition: string): this

where(condition: string, ...params: QueryValue[]): this

andWhere(condition: string, ...params: QueryValue[]): this

orWhere(condition: string, ...params: QueryValue[]): this

whereExists(query: string | SqliteQueryBuilder, params?: QueryValue[]): this

andWhereExists(query: string | SqliteQueryBuilder, params?: QueryValue[]): this

orWhereExists(query: string | SqliteQueryBuilder, params?: QueryValue[]): this

whereNotExists(query: string | SqliteQueryBuilder, params?: QueryValue[]): this

andWhereNotExists(
    query: string | SqliteQueryBuilder,
    params?: QueryValue[],
): this

orWhereNotExists(
    query: string | SqliteQueryBuilder,
    params?: QueryValue[],
): this

whereInSubquery(
    columnExpression: string,
    query: string | SqliteQueryBuilder,
    params?: QueryValue[],
): this

andWhereInSubquery(
    columnExpression: string,
    query: string | SqliteQueryBuilder,
    params?: QueryValue[],
): this

orWhereInSubquery(
    columnExpression: string,
    query: string | SqliteQueryBuilder,
    params?: QueryValue[],
): this

whereNotInSubquery(
    columnExpression: string,
    query: string | SqliteQueryBuilder,
    params?: QueryValue[],
): this

andWhereNotInSubquery(
    columnExpression: string,
    query: string | SqliteQueryBuilder,
    params?: QueryValue[],
): this

orWhereNotInSubquery(
    columnExpression: string,
    query: string | SqliteQueryBuilder,
    params?: QueryValue[],
): this

having(condition: string, ...params: QueryValue[]): this

andHaving(condition: string, ...params: QueryValue[]): this

orHaving(condition: string, ...params: QueryValue[]): this

groupBy(expressions: string | string[]): this

orderBy(expression: string, direction?: QueryOrderDirection): this

limit(value: number): this

offset(value: number): this

page(value: number): this

pageSize(value: number): this

toSQL(): QueryBuildResult

all<TRow extends Record<string, unknown> = Record<string, unknown>>(): TRow[]

first<TRow extends Record<string, unknown> = Record<string, unknown>>():
    | TRow
    | undefined

allAsync<TRow extends Record<string, unknown> = Record<string, unknown>>(): Promise<
    TRow[],
>

firstAsync<TRow extends Record<string, unknown> = Record<string, unknown>>(): Promise<
    TRow
    | undefined,
>