DO API ideas

gistfile1.rb

connection = DataObjects::Connection.new(uri)
connection.close


# immediately executed statements

reader = connection.query('SELECT * FROM table WHERE id = ?', 1)
reader.set_types(Integer)  # returns self for chaining
reader.each { |row| ... }

result = connection.execute('INSERT INTO table (id) VALUES(?)', 1)
result.insert_id
result.affected_rows


# prepared statements

statement = connection.prepare('SELECT * FROM table WHERE id = ?')

bound = statement.bind(1)
bound.each { |row| ... }

statement = connection.prepare('INSERT INTO table (id) VALUES(?)')
result    = statement.execute(1)

# or maybe
bound = statement.bind(1)
bound.execute