[Feature]:[Pieces] Microsoft SQL Server piece — Entra ID (service principal) auth for Azure SQL
Problem
The microsoft-sql-server piece supports SQL Server authentication only. auth.ts exposes host/port/database/user/password and a connection string, and buildConfig in src/lib/common/index.ts explicitly throws on any Authentication=Active Directory* connection string. A tenant configured for Entra SQL auth with an app registration has no way to connect.
Ref: Pylon 6019
Proposed
Add Entra service principal auth to the connection: Tenant ID, Client ID, Client Secret props, mapped to authentication: { type: 'azure-active-directory-service-principal-secret', options: { clientId, clientSecret, tenantId } }. Lift the Active Directory rejection when those fields are set.
No new dependency: mssql 12.7.0 pulls tedious 19.2.2, which already bundles @azure/identity and supports this auth type. Existing SQL-auth connections unchanged.
Source: activepieces/activepieces