Allow ActiveRecord::QueryMethods#select to accept a hash

oleksandr_g · July 16, 2022, 4:06pm

Idea is to allow #select to receive hash with aliases

For example, when we using joins on different tables and we need to prepare some specific response rely on few of them, we need to write it as:

Order.joins(:users).select("users.full_name as user_name, orders.amount as order_amount, orders.created_at as order_created_at")

I propose to add ability to use hashes instead raw sql here:

Order.joins(:users).select(users: { full_name: :user_name }, orders: { amount: :order_amount, created_at: :order_created_at })

We already have something similar for #where in context of using it with #joins so I think it might be helpful to improve codebases and remove raw sql from these place as well.

UPD: I created PR for this suggestion: https://github.com/rails/rails/pull/45612

simi · July 22, 2022, 2:10pm

I love this feature, since I was looking for column aliasing for some time already. I’ll test this locally, usually there were some problems with preloading (joins). Also looking at the implementation, maybe there is chance to actually use Arel capabilities to build the SQL select part. I’ll check locally as well and comment on PR if I found a better way.

oleksandr_g · July 22, 2022, 2:27pm

Hello and thanks for reply, it’s defiantly might be done with Arel but I wanted to avoid deep changes on it so prepared light version of preparing SQL before sending it to Arel part

simi · July 23, 2022, 2:55pm

I just realized I tried to contribute similar change already, but there was no interest.

github.com/rails/rails

Add support for aliasing selected fields.

rails:master ← simi:select-alias

opened 03:22PM - 18 Jul 20 UTC

simi

+51 -12

### Summary Often I would like to include some calculation for grouped value …within SELECT statement. I need to reselect default selection and add sql fragment for aliasing aggregation function result. ```ruby Account.joins(:users).group(:id).select('accounts.*, count(users.id) AS user_count') #=> SELECT accounts.*, count(users.id) AS user_count FROM "accounts" INNER JOIN "users" ON "users"."account_id" = "accounts"."id" GROUP BY "accounts"."id" LIMIT $1 ``` With this patch I can get same query with following: ```ruby Account.joins(:users).group(:id).select('accounts.*', 'count(users.id)' => :user_count) #=> SELECT accounts.*, count(users.id) AS user_count FROM "accounts" INNER JOIN "users" ON "users"."account_id" = "accounts"."id" GROUP BY "accounts"."id" LIMIT $1 ``` When combined with https://github.com/rails/rails/pull/39873, it is possible to use (IMHO) nicer approach: ```ruby Account.joins(:users).group(:id).select_append('count(users.id)' => :user_count) #=> SELECT accounts.*, count(users.id) AS user_count FROM "accounts" INNER JOIN "users" ON "users"."account_id" = "accounts"."id" GROUP BY "accounts"."id" LIMIT $1 ``` ### TODO - [ ] changelog entry - [ ] documentation

Topic		Replies	Views
Support for alias_attribute with SQL aliasing? rubyonrails-talk feature , activerecord	2	735	October 24, 2022
[ActiveRecord] feature request - QueryMethods method that augments the select clause. rubyonrails-core	5	329	November 15, 2019
Add `ActiveRecord::Base#[]` rubyonrails-core feature	6	673	September 8, 2021
Share queries hard to build with plain ActiveRecord rubyonrails-talk activerecord	2	959	July 21, 2020
Subqueries on joins. rubyonrails-core	2	161	December 14, 2015

Allow ActiveRecord::QueryMethods#select to accept a hash

Related Topics

More Resources