We are excited to announce the new release of the new version 2.1.1 of our SQL Enlight Code Quality plugin for SnarQube.

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.

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.

The SQL Enlight Code Quality plugin is available for download here; details about it can be found here.