It's implemented the same way it's implemented on any OS. SQLite is little more than a static library that works with a specific file format. There's no "server", etc. that's what makes it so "lite". Every application that uses an SQLite database has everything it needs to work with the database built-in.
Use can use any SQLite tools or libraries you'd like that you can get for your platform. You just need to point them to your database file.