Implement additional lint rules to detect anti patterns

[k-allagbe]

Problem

We need to catch Python anti-patterns in our codebase. Anti-patterns are bad practices that can lead to buggy, hard-to-read, or unmaintainable code.

Details

We can use lint rules based on the Python Anti-Patterns guide.

ADR candidate?

[rngadam]

@k-allagbe also suggests we move this issue to devsecops as it applies to the whole codebase. I don't think an ADR is necessary as what we want is the tooling to automaticallly enforce this.

Note that commenting on anti-pattern could probably be done by a chatgpt bot (with context on the anti-patterns rules)

[SonOfLope]

We could potentially look into SonarQube

Anti-pattern plugin : https://github.com/davidetaibi/sonarqube-anti-patterns-code-smells