How does ActiveRecord query interface work internally?

ActiveRecord translates Ruby method chains into SQL queries using an internal relation builder.

ActiveRecord uses lazy evaluation with Relation objects. Methods like where, select, and joins build an abstract query tree which is only executed when needed. The final SQL is generated by Arel and adapters.