SQL QueryBuilder type-safe, tiny poc

queryBuilderTS.ts

interface QbWithSelection <T extends Record<string, any> = never, Return = T> {
	where: (condition: Partial<T>) => QueryBuilder<T, Return>

	join: <NT extends Record<string, any>>(tableName: string) => QueryBuilder<T & NT, Return>

	limit: (n: number) => QueryBuilder<T, Return>

	offset: (n: number) => QueryBuilder<T, Return>

	orderBy: <K extends keyof T>(columns: Array<K>, by: "ASC" | "DESC") => QueryBuilder<T, Return>

	getQuery: () => string

	run: () => Return
}

interface QueryBuilder <T extends Record<string, any> = never, Return = T> {
	readonly _R: Return

	select: <K extends keyof T>(columns: Array<K>, from: string) => QbWithSelection<T, Pick<T, K>>

	selectAll: (from: string) => QbWithSelection<T, T>
}

declare const qb: QueryBuilder<{ id: string, name: string, age: number } & { vehicleName: string }>