rom-sql-write.rb

require 'rom-repository'
require 'rom-sql'

db = ROM.container(:sql, 'sqlite::///tmp/foo.sqlite') do |c|
  c.default.create_table(:users) do
    primary_key :id
    column :name, String, null: false
  end
end

class UserRepo < ROM::Repository[:users]
  commands :create, update: :by_pk
end

user_repo = UserRepo.new(db)
user = user_repo.create(name: 'Mel')

p user_repo.users.to_a