SQL Enlight For Developers 2.0.3.87

We are excited to announce the release of SQL Enlight for Developers, version 2.0.3.87.

This update includes several improvements and fixes:

• The analysis engine now supports more rules that can operate without requiring an SQL connection, using only the analysis context.
• The AnalysisContext CLI command can now generate metadata for multiple databases in a single context file and export SQL module definitions.

Analysis rules enhancements and fixes:

• The following rules can now operate solely with the analysis context: SA0040, SA0041, SA0047, SA0048b, SA0049B, SA0051, SA0122, SA0139, SA0237, SA0238.
• Enhanced cross-database support for these rules: SA0040, SA0047, SA0048b, SA0049B, SA0051, SA0095, SA0114B, SA0122, SA0126, SA0131, SA0137, SA0237, SA0238, SA0246.
• Updates to improve type resolution for these rules: SA0124, SA0126, SA0132.

Other enhancements and fixes in analysis rules:

• SA0042b: Fixed an issue that was preventing the reporting of issues found inside SQL modules.
• SA0051: Corrected a false positive related to PIVOT/UNPIVOT operators.
• SA0079: Fixed issue rule not being applied due to incorrect rule type
• SA0092b: Resolved an issue preventing reports and added default values for QUOTED_IDENTIFIER and ANSI_NULLS.
• SA0126: Fixed the assignment operator issue in WITH clauses.
• SA0139: Addressed a false positive when NULL is used as an argument.
• SA0172: Improved detection of unsafe usage of non-NVARCHAR variables in dynamic SQL.
• SA0237: Added parameters to ignore tables with identity columns.
• SA0263: Enhanced detection of dynamic SQL usage issues.