Depending on the application could you just mount a filesystem that supports encryption? Even if it’s just mounting a .tar file.

Turso: https://docs.turso.tech/libsql#encryption-at-rest

Also, DuckDB devs said it was planned: https://github.com/duckdb/duckdb/discussions/4512

SQLCipher fits that bill. I had some issues with language integration but depending on what you're using it might work for you.

The application encrypts the data, you save in the database the data encrypted. When you retrieve the info, the app decrypt it.

Well, sqlite

https://github.com/utelle/SQLite3MultipleCiphers/

Firebird: 13.8. Database Encryption https://www.firebirdsql.org/file/documentation/chunk/en/refdocs/fblangref30/fblangref30-security-dbcrypt.html

Encryption is usually implemented in the server or client code. Why do you want the database to handle encryption?