If you have decided to use sqlite, I would definitely recommend using the mORMot.
Learning curve is steep, but the reward(s) will be high.
Switching from sqlite towards postgresql or mysql or Mongo is as simple a changing one line of source-code.
Besides, mORMot offers static binding of the sqlite3 engine (with encryption). So, the only thing that is needed is a single executable. And it offers easy REST, websockets and many many more features. And a very active community.
Again, it will consume learning time, but extensive help (docs/people) is available.