Dbt-sqlserver

- Minor fix in no lock behaviour https://github.com/dbt-msft/dbt-sqlserver/pull/557

- Restores no lock behaviour from 1.4.2

- Fixes problem where databases with dashes are rendered properly

Updates dbt-sqlserver to support dbt 1.8.

Notable changes

- Adopts `dbt-common` and `dbt-adapters` as the upstream, in line with dbt projects.
- Implements the majority of the tests from the `dbt-test-adapters` project to provide better coverage.
- Implements better testing for `dbt-sqlserver` specific functions, including indexes.
- Realigns to closer to the global project, overriding some fabric specific implementations
- Adds new 1.8 features (and tests), including Unit Tests

Update also fixes a number of regressions related to the fabric adapter and 1.7 releases.
These include

- Proper ALTER syntax for column changes (in both )
- https://github.com/dbt-msft/dbt-sqlserver/pull/504/files
- Restoring cluster columntables post create on `tables`
- https://github.com/dbt-msft/dbt-sqlserver/issues/473
- Adds proper constraints to tables and columns
- https://github.com/dbt-msft/dbt-sqlserver/pull/500

There is a number of other changes as well, which can be found in the 1.8.0rc1, 1.8.0rc2 and 1.8.0 release notes.

While not directly included, credit also to **ms32035**, **axellpadilla**, **gbarrington**, **tkirschke** and others for their help with testing.

Huge thanks to GitHub users **cody-scott** and **prescode** for help with this long-awaited update to enable `dbt-core` 1.7.2 compatibility!

Updated to use dbt-fabric as the upstream adapter (https://github.com/dbt-msft/dbt-sqlserver/issues/441#issuecomment-1815837171)[https://github.com/dbt-msft/dbt-sqlserver/issues/441#issuecomment-1815837171] and (https://github.com/microsoft/dbt-fabric/issues/105)[https://github.com/microsoft/dbt-fabric/issues/105]

As the fabric adapter implements the majority of auth and required t-sql, this adapter delegates primarily to SQL auth and SQL Server specific
adaptations (using `SELECT INTO` vs `CREATE TABLE AS`).

Additional major changes pulled from fabric adapter:

- `TIMESTAMP` changing from `DATETIMEOFFSET` to `DATETIME2(6)`
- `STRING` changing from `VARCHAR(MAX)` to `VARCHAR(8000)`

Future work to be validated

- Fabric specific items that need further over-rides (clone for example needed overriding)
- Azure Auth elements to be deferred to Fabric, but should be validated
- T-SQL Package to be updated and validated with these changes.
- Integration of newer dbt-core features.

Another minor release to follow up on the 1.4 releases.

Replacing the usage of the `dm_sql_referencing_entities` stored procedure with a query to `sys.sql_expression_dependencies` for better compatibility with child adapters.