[BUG]: Using sql.placeholder with limit and/or offset for a prepared statement produces TS error

[vince-winkintel]

What version of drizzle-orm are you using?

0.30.7

What version of drizzle-kit are you using?

0.20.14

Describe the Bug

Given the following code,

const database: PlanetScaleDatabase = drizzle(client);
const prepared = database
    .select()
    .from(product)
    .orderBy(product.name)
    .limit(sql.placeholder('limit'))
    .offset(sql.placeholder('offset'))
    .prepare();

TypeScript will throw an error on the use of sql.placeholder for both limit() and offset() functions. The exact message is:

Argument of type 'Placeholder<"limit", any>' is not assignable to parameter of type 'number'.ts(2345)

Argument of type 'Placeholder<"offset", any>' is not assignable to parameter of type 'number'.ts(2345)

A workaround is to use the as never assertion to defer type inference and successfully compile.

...
    .limit(sql.placeholder('limit') as never)
    .offset(sql.placeholder('offset') as never)
    .prepare();

Expected behavior

No typescript error when using sql.placeholder with limit and/or offset for a prepared statements.

Environment & setup

No response

[lovrozagar]

Up

[AndriiSherman]

was fixed in drizzle-orm@0.36.1