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.