How to alias a column during a select?

[narigama]

I'm looking to generate SELECT table.foo as bar style syntax to make handling a poorly named column more ergonomic. Whilst I can generate table.foo, I can't find anything to handle the aliasing.

[seijikun]

This should work using something like:

let mut query = Query::select();
   query.expr_as(
       Expr::col(db::Table::Column::Foo),
       Alias::new("bar")
   )

[seijikun]

If it helped you, can you please also mark the answer?