10 replies

Using relation columns in where clause (Drizzle playground provided)

I have a one-to-one relationship with a schema defined like: https://drizzle.run/uwkkt8l10cgp5okr1r41tjfu

When I run that query, I get the following error

column agent.deleted does not exist

column agent.deleted does not exist

. Why can't you reference relation columns in a top-level where clause? Is there a better way to do this without using the

select

select

API with joins?

Drizzle Run