Database#execute does not return a ResultSet

[rickhull]

See the FAQ here: https:/sparklemotion/sqlite3-ruby/blob/main/FAQ.md#how-do-i-discover-metadata-about-a-query

rows = db.execute( "select * from table" )
p rows[0].fields
p rows[0].types

This doesn't actually work. Database#execute returns an Array of Arrays.

require 'sqlite3'

db = SQLite3::Database.new('tmp.db')
rows = db.execute "select true"

p rows[0].fields #=> undefined method `fields' for an instance of Array (NoMethodError)

The FAQ seems to imply ResultSet behavior, but AFAICT, you only get a ResultSet from Statement#execute but not Database#execute. I lean towards unifying the behavior.

[flavorjones]

@rickhull Thanks for pointing this out.

The behavior you're seeing (Database#execute returning an array) has not changed at least since 2005. The FAQ (which was written in 3e5a784 circa 2014) is in error. If you'd be willing to correct the FAQ in a PR that would be very valuable and you would have my thanks!

Changing what that method returns now would break many applications, unfortunately.