We have some hand-written queries in coderd/database/modelqueries.go that need to be updated manually sometimes, in contrast to most of our queries which are generated automatically based off of our database schema. We also have some tests that will fail when these queries become out of date, which is good, but the error messages the tests end up giving don't point in the right direction.

We should improve the test cases to more directly guide you to the right place.