Of course, by default SQL keywords and identifiers are case insensitive. In additional, SQLite LIKE is case-insensitive only for ASCII.
However, case-sensitive identifiers can be enabled in PostgreSQL, but not SQLite.
Situation helps greatly, if you can compile your own SQLite, perhaps natively, or with Rust or Golang.
As for unicode-enabled SQLite case-sensitive LIKE, I have seen people compile their own COLLATION in Rust.