When will VS 2019 compatible version be released
When will a VS 2019 compatible version of SQLite be released?
I just tried in VS2019 community version to download the 3.3 version of SQLITE via extention manager and got warning that this could destabilize VS2019.
I assume you're referring to this, which isn't maintained by the SQLite core team. You'll have to contact the author to work out why it's giving the complaint you're seeing.
SQLite as officially distributed is just C code or executables compiled from that C code.
If the source code doesn't compile on your compiler, then you need to post the errors you get rather than demand compatibility with a given compiler: not only are you not owed support for this free software, most of the time such "incompatibilities" are pilot error, so we've learned to put the burden of proof on the person claiming the incompatibility.
As for the pre-built executables, they are as compatible with VS2019 as any other third-party executable. The DLL build, for example, should link to any VS2019 C or C++ program without complaint. If it doesn't, search this forum for past messages containing the error you're getting: chances of pilot error are high here, too, and you probably aren't the first to have encountered that problem.
SQLite3 compiles and works just fine with the latest/current version of the Visual Studio compiler (within the capabilities of the compiler which is itself somewhat limited).
That is version 16.7.5 and C/C++ compiler version 19.27.29112.
Referring to something as "Visual Studio 2019" is sort of like referring to "Windows" -- it is completely non-diagnostic and fact free (despite the fact that the "Windows" ABI has been stable (as in mostly unchanged) for more than a decade).