This is really nice, just wanted to add to your list that you can extend SQLite in python with peewee orm: https://docs.peewee-orm.com/en/latest/peewee/sqlite_ext.html...

The workflow is basically prototype your virtual tables in python and then write some optimized code in a lower level language later. Just an idea for those interested.