Backport warning prevention from 1.9

[benc-db]

Description

Users reported that the cursor warnings were concerning, so backporting to 1.8 and to 1.7

Checklist

• [x] I have run this code in development and it appears to resolve the stated issue
• [x] This PR includes tests, or tests are not required/relevant for this PR
• [x] I have updated the CHANGELOG.md and added information about my change to the "dbt-databricks next" section.