Build SQLite with SQLITE_ENABLE_PERCENTILE for Windows and CPython-3.15+

Feature or enhancement

Proposal:

For Windows, CPython-3.15 requires SQLite-3.53.2. Since 3.51.0, the aggregate functions median and percentile are part of SQLite's amalgamation. I believe that this means that they are found to be mature. To have them available at run-time, SQLite needs to be built with SQLITE_ENABLE_PERCENTILE. Python's PCBuild activates a few built-in extensions of SQLite, but not this one yet.
Inserting SQLITE_ENABLE_PERCENTILE here might be everything needed.

Has this already been discussed elsewhere?

This is a minor feature, which does not need previous discussion elsewhere

Links to previous discussion of this feature:

I have not found previous discussions on this topic.

This discussion is about the ability to load SQLite extension modules at run-time, which is somehow related, as it can be used as an (inconvenient) fallback.

Another fallback is to implement these statistical functions in Python and bind them to a data base connection. This works, but is slower than having them built into SQLite (76s vs. 68s in my non-repesentative query).

Linked PRs

• gh-153867
• gh-153869
• gh-155101
• gh-156048
• gh-156446
• gh-156448

PCbuild/sqlite3.vcxproj で、issue で参照されている SQLite のコンパイル定義から始め、CPython が Windows 向けに SQLite 拡張機能を有効化する方法を調べてください。リンクされている PRs を使って現在の実装と検証を理解しながら、Windows ビルドが実行時に SQLite の中央値関数とパーセンタイル関数を公開していることを確認してください。