Delphi will statically link the SQLite DLL to your application, but what if you need to use an updated driver to take advantage of new features in SQLite. Well, you can dynamically link an updated DLL. Watch here.
More about this (and instructions) in my StackOverflow question.