Zero sonar code smells at ng-default

[mshima]

Overview of the feature request

We have 18 missing code smells now.
We can make it to zero.

Suggested fixes (originally posted at #25137 (comment)):

• QueryService (6): Add a Specification Builder and functional apis at jhipster-framework to simplify the application side.
• CacheConfiguration: ignore at sonar.properties or use metamodel for jpa.
• LiquibaseConfig: add a JHipsterProperty for async disabling
• Commented codes: drop or move to the generator's README.md and add a link to it.

Motivation for or Use Case

Related issues or PR

#25137

• Checking this box is mandatory (this is just to show you read everything)

[mshima]

The remaining code smells (6 for jpa model filtering and 6 for patch support #25153) are harder to fix.

[mshima]

New sonar rules. 231 issues now.

[mshima]

We have 110 issues which 98 are false positives.

[qmonmert]

False positives are fixed.
There are just issues like Refactor this method to reduce its Cognitive Complexity...

[mshima]

Code smells fixed in SonarSource/sonar-html#291