ActiveRecord pattern was popularized by Rails. It's the default ORM there.
Conventions
Rails ActiveRecord is driven by conventions: class names are mapped to table names, field names are mapped to field names, foreign and primary keys should be named accordingly. These conventions can be overridden.
Query
Having the following schema:
CREATE TABLE products (
id int(11) NOT NULL auto_increment,
name varchar(255),
PRIMARY KEY (id)
);
And the following code:
class Product < ApplicationRecord
end
p = Product.new
p.name = "Some Book"
p.save!
Will produce the following statement:
INSERT INTO products (name) VALUES ("Some Book");