So far, I have seen two things.
- Extensions. Most common one is probably REGEXP.
- Custom collations. Recently, I saw UNICASE, which is probably some kind of ASCII-based unicode normalization.
I have never tried SQLCypher or auths, and I don't get yet why I would use it.
In a language, there are probably also alternative drivers, beyond the default ones as well; at least in Python and Node.js. Also, JDBC-interface (i.e. Java driver) can also be used in both languages.
Closest I have to writing C code is writing cgo. But I don't know to write Rust, or real C/C++ code.
I see that custom built SQLite driver is also possible. But, it would hinder using DB Browser for SQLite, or reverse-engineering?