pypy 7.3.8 package for linux has an ancient sqlite3 version
the binary for pypy 7.3.7 ships sqlite3 with version 3.34.1 of SQLite, fairly recent about a year old.
7.3.8 just released seems to ship sqlite 3.7.17, which is nine years old (yes it's breaking things here, but we can work around). This certainly seems like a mistake, otherwise would be curious to know why this was intended.
Python 3.7.12 (c8af402943f0c6c9155c76a45e3b64103783aacf, Feb 18 2022, 12:25:20)
[PyPy 7.3.8 with GCC 10.2.1 20210130 (Red Hat 10.2.1-11)] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>>> import sqlite3
>>>> sqlite3.sqlite_version
'3.7.17'
>>>>
[classic@photon3 sqlalchemy:review/mike_bayer/nesting_cte]$ pypy3.7
Python 3.7.12 (50abf90efa6f, Nov 11 2021, 16:15:24)
[PyPy 7.3.7 with GCC 11.2.1 20210728 (Red Hat 11.2.1-1)] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>>> import sqlite3
>>>> sqlite3.sqlite_version
'3.34.1'
I'm running on Fedora 34 but we are seeing this on ubuntu workers as well.