SqlServer SqlDatabaseBackup check errors on Azure SQL

[Baune8D]

Note: If you have a feature request, you should contact support so the request can be properly tracked.

Output of the info page

Not able to provide this since i cannot run commands on a GKE AutoPilot cluster

Additional environment details (Operating System, Cloud provider, etc):
GKE AutoPilot 1.27.3
Helm Chart 3.52.0

Steps to reproduce the issue:

1. Activate SqlServer integration through Helm chart using the following values:

confd:
    sqlserver.yaml: |-
      cluster_check: true
      init_config:
      instances:
        - dbm: true
          host: <host>
          database: <database>
          username: datadog
          password: <password>
          connector: odbc
          driver: FreeTDS
          include_tempdb_file_space_usage_metrics: false
          azure:
            deployment_type: sql_database
            fully_qualified_domain_name: <host>

Describe the results you received:
We keep seeing the following error in the logs:

2024-01-24 16:22:41 UTC | CORE | ERROR | (pkg/collector/python/datadog_agent.go:129 in LogMessage) | sqlserver:3307f5f38b987a83 | (sqlserver.py:800) | Error running `fetch_all` for metrics SqlDatabaseBackup - skipping.  Error: ('42000', "[42000] [FreeTDS][SQL Server]Reference to database and/or server name in 'msdb.dbo.backupset' is not supported in this version of SQL Server. (40515) (SQLExecDirectW)")

Describe the results you expected:
Would expect it to run without errors

Additional information you deem important (e.g. issue happens only occasionally):
It also seems to have issues parsing the SQL Server version:

2024-01-24 14:11:07 UTC | CORE | WARN | (pkg/collector/python/datadog_agent.go:131 in LogMessage) | sqlserver:e8ed6cd493a183af | (sqlserver.py:282) | failed to parse SQL Server major version from version: Microsoft SQL Azure (RTM) - 12.0.2000.8
	Nov  2 2023 01:40:17
	Copyright (C) 2022 Microsoft Corporation

I see no way of defining this manually for Azure SQL.