Absolutely! I have the above SQL code in a Postgres stored function, and call it via ActiveRecord's find_by_sql() and use it in one of my Message model's method

Absolutely! I have the above SQL code in a Postgres stored function, and call it via ActiveRecord's find_by_sql() and use it in one of my Message model's methods to populate a bunch of Message instances.