[BUG]: Deeply nested queries fail due to table name length about drizzle-orm

[jonatandorozco]

I'm experiencing a similar issue, where the query says the column does not exist due name truncating

[gmanavarro]

Just ran into the exact same issue

[EamonHeffernan]

@EamonHeffernan did you figured out anything for this?

I'm not a maintainer, the only workaround I've found in my own code is to either do it without query which defeats the whole point of having the query system, or to instead break it into small enough queries that don't run into this issue. I've attempted to put this issue into the discord to get some attention about it. But this seems like such a simple case to run into because it doesn't take that much nesting to run into it if you have decently long table names.

[driwand]

@EamonHeffernan did you figured out anything for this?