Qry
Usage
Connect
require 'qry'
qry = Qry.connect(...) # Same arguments as Sequel gem
Run
qry.run(<<~SQL)
create table fruits (
id integer not null primary key autoincrement,
name varchar(255)
)
SQL
Insert
qry.insert('insert into fruits (name) values (?), (?)', 'Strawberry', 'Orange')
Fetch
fruits = qry.fetch('select * from fruits')
fruits.size fruits[0].name fruits[1].name
Update
qry.update('update fruits set name = ? where id = ?', 'Mango', fruits[0].id)
fruits = qry.fetch('select * from fruits')
fruits[0].name fruits[1].name
Delete
qry.delete('delete from fruits where id = ?', fruits[1].id)
fruits = qry.fetch('select * from fruits')
fruits.size fruits[0].name