Lack of integration tests for SQL catalog implementation

[callum-ryan]

Following on from #610, #534, #524 and #610 (review) from @liurenjie1024.

The current test suite only runs against SQLite, for the catalog implementation to be robustly tested this should be extended to both PostgreSQL and MySQL.

I've already made a start on this, so happy to take this on!

[liurenjie1024]

Thanks @callum-ryan !

[github-actions]

This issue has been automatically marked as stale because it has been open for 180 days with no activity. It will be closed in next 14 days if no further activity occurs. To permanently prevent this issue from being considered stale, add the label 'not-stale', but commenting on the issue is preferred when possible.

[liurenjie1024]

We should keep this issue, we still need to add it.