> Only by writing and compiling some C

Or Rust - https://ricardoanderegg.com/posts/extending-sqlite-with-rust...