How to make SQL query in ActiveRecord using alias for the table?

Question

I want to make such a query for my Services ActiveRecord in Rails:

SELECT *
FROM "services" AS s
WHERE /* part using 's' alias */

Normally I'd write just Service.where(/* where part */), but I need to set my alias.

I tried to run ActiveRecord::Base.connection.execute(query), but result of that is not recognized as Service.

How can I handle it?

Tom Copeland · Accepted Answer · 2017-08-31 19:46:15Z

6

To use a table alias combine the select method with from:

Service.select("s.*").from("services s")

Which generates this SQL:

SELECT s.* FROM services s

And it returns an ActiveRecord::Relation which you can refine as needed.

answered Aug 24, 2017 at 17:03

Tom Copeland

1,28110 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Karol Selak · Accepted Answer · 2017-08-24 16:04:17Z

0

Fortunately I found solution during writing this question. Service.find_by_sql(query) works well in my case.

answered Aug 24, 2017 at 16:04

Karol Selak

4,8848 gold badges42 silver badges69 bronze badges