So, the final choice is dexie + custom backend? I've researched these open source solution before, I think dexie is the choice that you will never regret.

fyi https://dexie.org/

Sure, that works if you only operate in environments where IndexedDB is available.

On mobile and desktop, IndexedDB does not exist, and SQLite is available first-class.