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

Inizia con PCbuild/sqlite3.vcxproj, esaminando le definizioni di compilazione di SQLite a cui fa riferimento l’issue, e verifica come CPython abilita le estensioni SQLite per Windows. Verifica che la build Windows esponga le funzioni mediana e percentile di SQLite a runtime, usando le PRs collegate per comprendere l’implementazione e la validazione correnti.