Sqlite Spatial RevEng: Column SRID and Dimension not configured

[bricelam]

We need to query the SpatiaLite metadata tables in SqliteDatabaseModelFactory and add the annotations to DatabaseColumn objects.

[bricelam]

SELECT c.*, g.coord_dimension, g.srid
FROM pragma_table_info($table) c
    LEFT JOIN geometry_columns g
        ON g.f_table_name = $table COLLATE NOCASE
            AND g.f_geometry_column = c.name COLLATE NOCASE;