DT
Drizzle Team•13mo ago
Tomer Moran

Support for relational queries with views

Hello! I was wondering if there are plans to add support for relational queries with views? I am not presently able to define relations on a view as it is expecting a table as the first argument. Thanks!
2 Replies
bloberenober
bloberenober•13mo ago
Good catch, could you create a GH issue for that please?
rodrigo
rodrigo•11mo ago
I've found a trick. You can define the view natively in the db, and then a table in the schema, and it works. I guess there's still WIP with view ... https://github.com/drizzle-team/drizzle-orm/issues/769
GitHub
[BUG]: Can' use views with relations API · Issue #769 · drizzle-tea...
What version of drizzle-orm are you using? 0.26.5 What version of drizzle-kit are you using? No response Describe the Bug I can't use a pgView with the relations API. Example: export const user...
Want results from more Discord servers?
Add your server
More Posts
Many to many relationship between one typeI'm making an application where I have users who are able to follow other users. This means that I nHow can I order and/or limit rows from leftJoin?I have two tables, groups and exams, exam must have only group, group can have many exams. I'm selecCan someone help me understand these 2 examples using pool and client?I'm reading through the docs and see that in the 2 Neon examples, they use a pool and client. From Type Declaration with TypeScript in Monorepo failesI am trying to setup a monorepo with moon and pnpm, where shema lives in an additional package and iType error?``` import { pgTable, serial, integer } from 'drizzle-orm/pg-core'; export const users = pgTable('uUnsafe argument of type `any` inside select where eq queryI am getting the following type error even though I am not passing parameters of type `any`. Correct