How do you use SQL aliases in ActiveRecord queries (computed columns, subqueries, self-joins) safely?

Topic: rails, ActiveRecord and SQL. Level: Intermediate.

The full answer to this question is available to Interview Reader members. See what is free and what Premium adds.