virtualpg: update to version 1.0.1

- Upgrade to version 1.0.1
- Take advantage of compile options for non-canonical postgresql
  installs
- Fix link file extension to use dylib
- Add test of loading extension for sqlite3
- Closes #32042
The referenced name here should really be `mod_virtualpg`, not `mod_spatialite`. However, the noted issue in the link does apply to the general problem of SQLite loadable module naming on Mac.