upgrade to support dbt-core v1.2.0

[dataders]

We've just published the release cut of dbt-core 1.2.0, dbt-core 1.2.0rc1 (PyPI | GitHub release notes).

https://github.com/dbt-labs/dbt-core/discussions/5468 is an open discussion with more detailed information, and https://github.com/dbt-labs/dbt-core/issues/5474 is for keeping track of the communities progress on releasing 1.2.0

Below is a checklist of work that would enable a successful 1.2.0 release of your adapter.

• [x] migrate necessary cross-db macros into adapter and ensure they're tested accordingly
• [x] remove any copy-and-pasted materialization (if your adapter inherits from another adapter)
• [x] add new basic tests BaseDocsGenerate and BaseDocsGenReferences
• [x] consider checking and testing support for Python 3.10

https://github.com/dbt-labs/dbt-core/pull/5432 might make it into the second release cut in the next week, in which case, you'll also might want to:

• [x] implement method and tests for connection retry logic

[pmishchenko-ua]

Closing with https://github.com/memsql/dbt-singlestore/commit/21706bd85ed498e08099bb398f7b0c3ef3c915a6