instance method to_sql

Ruby on Rails 5.1.7

Since v3.0.20

Available in: v3.0.20 v3.1.12 v3.2.22.5 v4.0.13 v4.1.16 v4.2.11.3 v5.0.7.2 v5.1.7 v5.2.8.1 v6.0.6.1 v6.1.7.10 v7.0.10 v7.1.6 v7.2.3.2 v8.0.5.1 v8.1.3.1 edge

Signature

to_sql()

Returns sql statement for the relation.

User.where(name: 'Oscar').to_sql
# => SELECT "users".* FROM "users"  WHERE "users"."name" = 'Oscar'
Source
# File activerecord/lib/active_record/relation.rb, line 569
    def to_sql
      @to_sql ||= begin
                    relation = self

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

                    conn = klass.connection
                    conn.unprepared_statement {
                      conn.to_sql(relation.arel, relation.bound_attributes)
                    }
                  end
    end

Defined in activerecord/lib/active_record/relation.rb line 569 · View on GitHub · Improve this page · Find usages on GitHub

Defined in ActiveRecord::Relation

Type at least 2 characters to search.

Use the arrow keys to navigate results, Enter to open one, Escape to close.

Keyboard shortcuts

/
Focus search
⌘K / Ctrl-K
Command palette
?
This help
Esc
Close