Recently I've been working on the DBIx::Class::Schema::Loader support for
SQLite -- specifically, removing all of the "parse SQL from sqlite_master"
hacks from it. Things have been going quite well, but the heuristic I have for
determining whether a column is an autoinc PK is fragile.
I see that SQLite provides a definitive answer to the question of whether a
column is autoinc via the sqlite3_table_column_metadata API function, and
DBD::SQLite already makes use of this function to provide the NULLABLE sth
attribute. Does adding a private statement handle attribute that
returns the autoinc information from the same API function sound like a
reasonable solution to my problem?
Andrew Rodland (IRC: hobbs)