[BUG]: Cannot chain methods to type db.select()

[ridhwaans]

What version of drizzle-orm are you using?

^0.30.10

What version of drizzle-kit are you using?

^0.21.4

Describe the Bug

let query = db
        .select()
        .from(postsTable)
        .leftJoin(...
        
        
     const whereConditions = [];
        if (input?.genreName) {
          whereConditions.push(eq(genresTable.name, input.genreName));
        }
        if (input?.keyword) {
          whereConditions.push(eq(keywordsTable.name, input.keyword));
        }
    
        if (whereConditions.length > 0) {
          query = query.where(or(...whereConditions)); // error
        }

if you need to conditionally include certain where filters, its not easy to build a select query

Property 'where' is missing in type 'Omit<import("/node_modules/drizzle-orm/sqlite-core/query-builders/select").SQLiteSelectBase<"movies", "async", import("/node_modules/@libsql/core/lib-esm/api").ResultSet, Record<"movies", { id: import("/node_modules/drizzle-orm/sqlit...' but required in type 'Omit<import("/node_modules/drizzle-orm/sqlite-core/query-builders/select").SQLiteSelectBase<"movies", "async", import("/node_modules/@libsql/core/lib-esm/api").ResultSet, Record<"movies", { id: import("/node_modules/drizzle-orm/sqlit...'.ts(2741)
select.d.ts(379, 5): 'orderBy' is declared here.
let query: Omit<SQLiteSelectBase<"posts", "async", ResultSet, Record<"posts", {
    id: SQLiteColumn<{
        name: "id";
        tableName: "posts";
        dataType: "number";
        columnType: "SQLiteInteger";
        data: number;
        driverParam: number;
        notNull: true;
        hasDefault: true;
        enumValues: undefined;
        baseColumn: never;
    }, object>;
    ... 20 more ...;
    ...

Also, it would be beneficial if combining filters accepts a list structure

.where(
or(
[eq(...),..]
))

Expected behavior

It should not produce an error when building a select query. Or support nested filters in findMany

Environment & setup

node