[BUG]: findManyAndCount fails when using relations filters

[icomad]

I am using drizzle-plus@1.0.0-beta.34 and drizzle-orm@1.0.0-beta.1-4e7eaa6 and when I try to run a findManyAndCount query using relations filters I get this error TypeError: undefined is not an object (evaluating 'casing.getColumnCasing').

I am not really familiar with drizzle-orm source code but I saw that in your src/generated/internal.ts on line 51 you call the function relationsFilterToSQL like this:

relationsFilterToSQL(
    ctx.table,
    filter,
    ctx.tableConfig.relations,
    ctx.schema,
    ctx.tableNamesMap,
    ctx.dialect.casing
  )

but relationsFilterToSQL type is

export declare function relationsFilterToSQL(table: SchemaEntry, filter: AnyRelationsFilter | AnyTableFilter, tableRelations: RelationsRecord, tablesRelations: TablesRelationalConfig, casing: CasingCache, depth?: number): SQL | undefined;

If I comment out ctx.tableNamesMap the query runs without issues but I don't know if I'm breaking something else without noticing it.

[jofflin]

I got the same issue.
In my relations is filter out my softdelete columns.

[jofflin]

I just build the project locally and I assume that drizzle did some changes to relationsFilterToSQL function because it shows me an error.

My workaround at the moment is that I included the package into my monorepo and fixed the bug.

[jofflin]

Are there any plans on updating the package?

[Pyakz]

up

[judehunter]

Facing the same issue, in my case just using .count directly, with a nested relation filter

[aleclarson]

Sorry, don't have time to fix this, but PR is welcome.