I added this to sqlite-utils in simonw/sqlite-utils#136 and I really like it: pass a special value of spatialite and Datasette should attempt to load it from known likely installation locations.