Best Practice for Selecting a Single Column with SelectTwo?

[Jason5Lee]

I'm writing code like this:

let record = Entity1::find()
    .find_also_related(Entity2)
    .filter(entity2::Column::Id.eq(target_id))
    .select_only()
    .column(entity1::Column::ColumnToSelect)
    .one(&self.connection)
    .await?;

However, I'm having trouble getting the query to work.

1. There seems to be no into_tuple method on SelectTwo in version 1.1.12, even though a PR implementing it has been merged.
2. I tried using into_partial_model, but it requires two type parameters. Besides the struct containing the field I need, I have to define an empty query result.

Is there a better way to achieve this?

[zefr0x]

 let record = Entity1::find()
     .find_also_related(Entity2)
     .filter(entity2::Column::Id.eq(target_id))
     .select_only()
-    .column(entity1::Column::ColumnToSelect)
+    .column_as(entity1::Column::ColumnToSelect, "A_column_to_select")
     .one(&self.connection)
     .await?;

does something like this work for you?

---

.select_only() will clear selects including their aliases and when adding them again with .column(...) it will not add the aliases again, so you need to do it manually.