I'm working with some code that stores data to a SQLite database using Poco::Data::SQLite. The database file needs to be compatible with other SQLite wrappers (like the SQLite ADO.NET wrapper "System.Data.SQLite"). SQLite is supposed to allow declaring arbitrary data types for columns in table definitions.
My problem is that I have a column that needs to be declared with a boolean flavor (BIT/BOOL/YESNO) so that the wrapper will correctly interpret its type, but it appears that in Poco::Data::SQLite::Utility::getColumnType(), only a handful of known or undeclared types are supported. Unsupported types are met with a nasty Poco::NotFoundException which is currently a show-stopper for me. Therefore I have two questions:
1) Would it be possible to either interpret a few more types, or at least utilize something like a default or the "sqlite_column_type" function to deduce the data type? The types that I'm trying to be senstive to can be found at http://sqlite.phxsoftware.com/forums/p/31/76.aspx#76.
2) Is it a violation of the Poco licensing to modify my local copy of the Poco source code to add this type of change/improvement?