Spatialite support

[chapmanjacobd]

# sq add test_api/test-data.sqlite
@test_data_sqlite  sqlite3  test-data.sqlite
# sq inspect
sq: failed to read @test_data_sqlite source metadata: no such module: VirtualSpatialIndex

[neilotoole]

@chapmanjacobd Do you have a (non-sensitive) sqlite db I could test against?

[chapmanjacobd]

either of these should work

https://github.com/dpmcmlxxvi/SpatiaLiteCpp/blob/master/examples/spatialite/test-2.3.sqlite

https://git.asi.ru/solutions/world-ai-and-data-challenge/trase/-/blob/fd8f090fb6f934890d4b5e95df4976c65f183292/aequilibrae/reference_files/spatialite.sqlite

[chapmanjacobd]

this might be helpful

https://github.com/malexer/spatialite/blob/master/spatialite/connection.py