Improve table identification

[RasmusSkytte]

Intent

This PR serves as a stop-gap for table identification issues being fixed for SCDB (ssi-dk/SCDB#93).
To make releasing these issues for SCDB as smoothly as possibly, we here make some small stop-gap changes so the updates don't break diseasystore

Incidentally, this PR also fixes issues with SQLite w. schemas.

Approach

Identification of tables is improved by using SCDB::id() explicitly some places and converting to corresponding character representations manually.

For drop_diseasystore, identification of where the diseasystore tables are located is now resolved by SCDB::id(). This is then used to create the relevant regex'es to match tables to delete.

Known issues

This PR also contains the code being merged in

• Add tests on SQL Server back ends #111
  Once merged, this PR will be rebased and opened.

Tests and checks for SCDB v0.4 is still failing.
Remember that these were added to track our progress towards SCDB v0.4 compatibility and not required to succeed for every PR.

Checklist

• The PR passes all local unit tests
• I have documented any new features introduced
• If the PR adds a new feature, please add an entry in NEWS.md
• A reviewer is assigned to this PR

[codecov]

Codecov Report

Attention: Patch coverage is 81.57895% with 7 lines in your changes are missing coverage. Please review.

Project coverage is 93.78%. Comparing base (4bd988b) to head (16d77f3).

Files	Patch %	Lines
R/drop_diseasystore.R	78.57%	6 Missing ⚠️
R/DiseasystoreBase.R	90.00%	1 Missing ⚠️

Additional details and impacted files

@@            Coverage Diff             @@
##             main     #121      +/-   ##
==========================================
- Coverage   95.00%   93.78%   -1.22%     
==========================================
  Files          14       14              
  Lines         980      997      +17     
==========================================
+ Hits          931      935       +4     
- Misses         49       62      +13     

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.