Access the Drizzle ORM client

[oldo]

I note that Drizzle is used when Postgres is the database in a Payload project. I'm pretty surprised at the lack of typesafety when making queries via the Payload client - there is no typesafety in the where clause of a find query for example. If Drizzle is indeed being used then somewhere there should be a fully typesafe Drizzle client - does Payload expose this anywhere?

I'm using Payload to build backend applications so it's kind of a deal breaker to have this basic level of typesafety.

[milamer]

Perhaps this helps
https://payloadcms.com/docs/database/postgres#access-to-drizzle

[oldo]

Oh my goodness, how did I not come across this before. TBH my experience with Payload has been really painful when it comes to wrangling relational data - this may be the turnaround. Has it always been there in the docs or was it something that was just added?