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
When I run that query, I get the following error
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 API with joins?
