lucasavila00 / sql-select-ts Goto Github PK

export const xxxxxxxx = (args: yyyyy) =>
    pipe(
        select(
            _f => ({
               ........
            }),
           table
        ).where(f => [
            //
           aaaaaa
        ]),
        groupSortLimit
    );

to remove usage of this pipe

Document selecting star of alias

Undefined table name creates hard to find bug

Docs for having

Examples using the same approach from bun, with CTE and subqueries

https://github.com/uptrace/bun

empty starting selection

Investigate replacing split-alias-with-dot with nested proxies

// this should work
t.select(f => ({"a.b": f.a.b}).select(f => ({"a.b": f["a.b"]})


// this should be distinguishable
select 1 as `t1.eid`, `t1`.`eid`, `t1.eid` from t1 limit 1

A little experiment should be possible without too much re-design on the type structure

Investigate changing order of selection

tableA
    .selectStar()
    .from(tableB.select()...)

Types are not compiled correctly


node_modules/sql-select-ts/lib/index.d.ts:108:467 - error TS1005: '?' expected.

108 export declare const except: <C extends SelectStatement<any, any>, CS extends SelectStatement<any, any>[]>(content: [C, ...CS]) => Compound<(C extends SelectStatement<infer _Scope extends string, infer Selection extends string> ? Selection : never) | (CS[number] extends infer T ? T extends CS[number] ? T extends SelectStatement<string, string> ? string : never : never : never), C extends SelectStatement<infer _Scope extends string, infer Selection extends string> ? Selection : never>;