class SQLite3::Database

executing statements.
See also #execute_batch for additional ways of

a block can be passed to parse the values accordingly.
Because all values except for 'NULL' are returned as strings,

If no query is made, an empty array will be returned.
If a query is made, all values will be returned as strings.

in turn. Bind parameters cannot be passed to #execute_batch2.
string, ignoring all subsequent statements. This will execute each one
means of executing queries will only execute the first statement in the
Executes all SQL statements in the given string. By contrast, the other

def execute_batch2(sql, &block)
  if block_given?
    result = exec_batch(sql, @results_as_hash)
    result.map do |val|
      yield val
    end
  else
    exec_batch(sql, @results_as_hash)
  end
end