SqlServerDsc: Remove `Invoke-SqlScript`

[johlju]

Pull Request (PR) description

• SqlServerDsc
  • Removed internal function Invoke-SqlScript that was a wrapper for the command Invoke-SqlCmd. The resources SqlScript and SqlScriptQuery was instead refactored to use Invoke-SqlCmd directly (issue #1896).

This Pull Request (PR) fixes the following issues

• Fixes #1896

Task list

• [x] Added an entry to the change log under the Unreleased section of the file CHANGELOG.md. Entry should say what was changed and how that affects users (if applicable), and reference the issue being resolved (if applicable).
• [ ] Resource documentation updated in the resource's README.md.
• [ ] Resource parameter descriptions updated in schema.mof.
• [x] Comment-based help updated, including parameter descriptions.
• [x] Localization strings updated.
• [ ] Examples updated.
• [x] Unit tests updated. See DSC Community Testing Guidelines.
• [x] Integration tests updated (where possible). See DSC Community Testing Guidelines.
• [x] Code changes adheres to DSC Community Style Guidelines.

---

This change is 

[codecov[bot]]

Codecov Report

Merging #1903 (2d63579) into main (ac13d70) will decrease coverage by 1%. The diff coverage is 100%.

@@         Coverage Diff          @@
##           main   #1903   +/-   ##
====================================
- Coverage    92%     92%   -1%     
====================================
  Files        86      86           
  Lines      7661    7631   -30     
====================================
- Hits       7059    7029   -30     
  Misses      602     602           

Flag	Coverage Δ
unit	92% <100%> (-1%)	:arrow_down:

Impacted Files	Coverage Δ
...dules/SqlServerDsc.Common/SqlServerDsc.Common.psm1	98% <ø> (-1%)	:arrow_down:
...urce/DSCResources/DSC_SqlScript/DSC_SqlScript.psm1	100% <100%> (ø)
...sources/DSC_SqlScriptQuery/DSC_SqlScriptQuery.psm1	100% <100%> (ø)

... and 1 file with indirect coverage changes

[johlju]

When attempting this the verbose functionality of PRINT and RAISEERROR statements are no longer outputted in the verbose output stream. For some reason having the wrapper in a separate module seems to trigger verbose output. Closing this PR as I can't get back that functionality which is important as it is used by Test() to return informational messages.