while trying to upgrade to sqlite 3.1.3, I've encountered the bug described in ticket #1141 (sqlite returns the primary key's column name, if any, instead of the ROWID column, in a query like SELECT rowid, * FROM table).
Any idea how to fix this (if it's an easy one), since it breaks existing applications.
SELECT rowid AS 'rowid',* FROM table
