That announcement relates to using the compilation database in batch analysis i.e. when using the CFamily build wrapper as part of a CI build.
Yes, SonarLint for Visual Studio supports vcxproj files and CMake (although not CMake presets). See the wiki for more information on CMake support.
Workaround: I know nothing about VS support for NMake. However, you could have a look at this post in which another user managed to make SonarLint for VS work with CMake presets by adding a dummy CMakeSettings.json file to point SonarLint to the compilation database.