This is just a personal reminder note that won't get lost in case I forget:

To convert a .dll to a linkable .lib

Enter the command prompt and type

LIB /DEF:sqlite3.def

You will also need sqlite3.h from the SQLite amalgamated source repository.