Insert statement in Arel

arel.rb

def insert_sql_for(table_name, data)
  stmt          = Arel::Nodes::InsertStatement.new
  stmt.relation = Arel::Table.new(table_name)
  stmt.columns  = data.keys.map { |k| Arel::Table.new(table_name)[k] }
  stmt.values   = Arel::Nodes::Values.new(data.values, stmt.columns)
  stmt.to_sql
end

require "active_record"
ActiveRecord::Base.establish_connection("postgres:///db")
ActiveRecord::Base.connection.execute(insert_sql_for :movies, data)

This worked for me on Rails 6

table = Arel::Table.new(:users)
manager = Arel::InsertManager.new
manager.insert [[table[:email], "test@example.com"]]
User.connection.insert(manager.to_sql)

(5.5ms)  INSERT INTO `users` (`email`) VALUES ('test@example.com')
=> 10 # Assigned ID