Hi! Here is a small patch which modifies the returned data set of the PRAGMA table_info() to add a new column named "auto_inc" which contains 1 if the corresponding field has the AUTO INCREMENT in its definition and 0 otherwise.
Could it be included in a future version of SQLite? Regards, Vivien