Tim Heuer has posted a walkthrough on how to install the SQLite runtime package for your WinRT apps and how to use it from your managed or native code:
http://timheuer.com/blog/archive/2012/08/07/updated-how-to-using-sqlite-from-windows-store-apps.aspx