Method `Where.querystring_for_update_and_delete` uses the wrong column name when using `db_column_name`

[VladislavYar]

The problem is similar #1111

  def querystring_for_update_and_delete(self) -> QueryString:
      args: list[Any] = []
      if self.value != UNDEFINED:
          args.append(self.value)

      if self.values != UNDEFINED:
          args.append(self.values_querystring)

      column = self.column

      if column._meta.call_chain:
          # Use a sub select to find the correct ID.
          root_column = column._meta.call_chain[0]
          sub_query = root_column._meta.table.select(root_column).where(self)

          # There must be something like `column_name = column._meta.call_chain[0]._meta.db_column_name or column._meta.call_chain[0]._meta.name`
          column_name = column._meta.call_chain[0]._meta.db_column_name or column._meta.call_chain[0]._meta.name
          return QueryString(
              f"{column_name} IN ({{}})",
              sub_query.querystrings[0],
          )
      else:
          template = self.operator.template.format(
              name=self.column.get_where_string(
                  engine_type=self.column._meta.engine_type
              ),
              value="{}",
              values="{}",
          )

          return QueryString(template, *args)

[sinisaos]

@VladislavYar Could you please give an example where we can try this. Thanks.

[VladislavYar]

@VladislavYar Could you please give an example where we can try this. Thanks.

@sinisaos of course

class Representation(Table, tablename="representations"):
    key = Varchar(length=LENGTH_KEY, unique=True, null=False)


class UserRepresentation(Table, tablename="user_representations"):
    representation = ForeignKey(
        Representation, on_delete=OnDelete.restrict, db_column_name="representation_id" # Rename column
    )


await UserRepresentation.delete().where(
    UserRepresentation.representation.key.is_in(
        ["Piccolo", "ORM", "very", "nice"]
    )
)
# asyncpg.exceptions.UndefinedColumnError: column "representation" does not exist
# HINT:  Perhaps you meant to reference the column "user_representations.representation_id".

[sinisaos]

@VladislavYar Thanks for the example. I think you're right. After I applied your fix, everything works, both delete and update. I think you should do a PR or wait for @dantownsend to see.

[dantownsend]

Ah yes, I can see the problem.