method

to_sql

v4.1.8 - Show latest stable - Class: ActiveRecord::Relation

to_sql()

public

Returns sql statement for the relation.

User.where(name: 'Oscar').to_sql
# => SELECT "users".* FROM "users"  WHERE "users"."name" = 'Oscar'

# File activerecord/lib/active_record/relation.rb, line 515
    def to_sql
      @to_sql ||= begin
                    relation   = self
                    connection = klass.connection
                    visitor    = connection.visitor

                    if eager_loading?
                      find_with_associations { |rel| relation = rel }
                    end

                    ast   = relation.arel.ast
                    binds = relation.bind_values.dup
                    visitor.accept(ast) do
                      connection.quote(*binds.shift.reverse)
                    end
                  end
    end

to_sql

Related methods