As a note, I'd suggest that a big flag be put up in the notes about the bundled SQLite module. It returns array(array) instead of array (mapping) from query(), such that it's not possible to use it with any code normally written for databases in Pike. /.../
But that's not new, is it? Certainly it should be fixed (or possibly deprecated and replaced with a rewritten module), but that'd require compat goo since there might be code that contains kludges to cope with this strange behavior.
A prominent @note in the refdoc string for that query function sounds like a good idea.