one-to-one relations with query, use joined table in where

    export const thingUsers = sqliteTable(...)
    export const users = sqliteTable(...)

    export const thingUsersRelations = relations(thingUsers, ({ one, many }) => ({
      user: one(users, {
        fields: [thingUsers.userId],
        references: [users.id],
        relationName: "user",
      }),
      thing: one(thing, {
        fields: [thingUsers.thingId],
        references: [thing.id],
        relationName: "thingUser",
      }),
    }));

    await db.query.thingUsers
      .findMany({
        with: {
          user: true,
          thing: true,
        },
        where: eq($.thing.publicId, publicThingId),
      });