upgrade to support dbt-core v1.8.0

[dataders]

Background

Minor version v1.8 is targeted for final release within dbt Core on May 9, 2024.

~~As a maintainer of a dbt adapter, we strongly encourage you to release a corresponding minor version increment to ensure users of your adapter can make use of this new minor version.~~

As of dbt-core v1.8.0, we no longer need to encourage you to release a new minor version anytime we do. After following the linked upgrade guide, we guarantee your adapter will be forward compatible with all future minor versions of dbt-core (at least until v2.0 which is not yet planned).

Another major win: you can now make your adapter truly SemVer compliant, as you can release new versions of your adapter without needing to wait for a new dbt-core release. You can actually follow

How to upgrade

https://github.com/dbt-labs/dbt-core/discussions/9798 is an open discussion with more detailed information. If you have questions, please put them there!

[tobiascadee]

@dbeatty10 any plans for this or are you open to a pr?

[stevetracvc]

@tobiascadee I've made my fork compatible with v1.9 so far (for mariadb only). I doubt it's fully compatible, so I haven't made a PR, I just needed foreign keys to work properly. But it's mostly just that dbt core moved some stuff to dbt_commons so you need to update imports.

I added a custom render_column_constraint so that I could add custom CASCADE expressions to the foreign keys.