Here is an article from Julia Evans explaining it: https://jvns.ca/blog/2019/10/28/sqlite-is-really-easy-to-com...
Or if you are familiar with Docker, you can use a more recent Debian in a container and install sqlite inside it.
As for a more recent Debian version: The latest stable Debian has sqlite3 3.27.2 in the repos, so that is not an option.
Here is an article from Julia Evans explaining it: https://jvns.ca/blog/2019/10/28/sqlite-is-really-easy-to-com...
Or if you are familiar with Docker, you can use a more recent Debian in a container and install sqlite inside it.