For users coming from SQ < 4.3 and who upgraded to more recent versions, the Rules table is not clean and has some leftovers coming from the refactoring of the SQALE model. The consequences are the following:
- when language plugins update their rule SQALE mapping, this is not taken into account during the analyses
- when language plugins update the implementation of some rules, this can lead to some failure during analyses (e.g. the rule does not provide an effort to fix but the overloaded remediation function is "linear" => SQ detects that there is a mismatch and fails)
For this reason, we should do a one-time migration that will clear the overloaded SQALE info on the Rules table.
- This should be done only if we detect that the SQALE plugin is not installed.
- Obviously we should display a clear message in the logs of the one-time migration