Thanks :) and yup, definitely, we were digging into the typed-sql repo just the other day.
I've made quite a bit of progress on incremental view maintenance for SQLite which I'd like to share in the near future if that's a problem you're also dealing with.