Hi there!
I create and publish the Windows binary installers/zips of Emacs currently.
I agree that there’s no sqlite DLL provided with the current Emacs 29 pre-release snapshot. I do plan to try updating the packaging environment and process to build that along with the rest of the DLLs that end up in emacs-*-deps.zip (meaning it also would be included in the full zip and self-installer).
To do this requires some updates in the build environment. I plan to hold off on that until after the Emacs 28.3 is released (currently Emacs 28.3 rc1 is available for testing).
Beside the change of screwing up during the updates and uncovering bugs related to new depenancy versions, updating the build environment before I build the 28.3 release would mean 28.3 would have different deps vs the other release in the Emacs 28 series.
Once 28.3 Windows binaries are published, I’ll update MSYS etc, get sqlite installed on the build env, and have a go at making a new set of snapshot binaries from the emacs-29 branch. I’ll try to remember to follow up here but welcome to ping me via private email Email or CC in messages to emacs-devel or the org mode mailing lists. (I do look at the lists but am way more likely to see messages where I’m CCd.)
Finally, until I have tried building with sqlite support myself I won’t be entirely sure, but… It’s very likely that you can copy a sqlite DLL from (e.g.) the MSYS32/MINGW64 sqlite package but (based on some mailing list comments from Eli), you may have to rename the DLL as well as copying it to the bin folder under your Emacs instalation/unpack location. If you have success trying that I’d love to hear about it.
corwin (at) bru (dot) st