Here is the query builder for SQLite.
This review depends on http://reviews.lunr.nl/r/83/
Note the following points concerning not supported features in SQLite compared to MySQL:
-REPLACE statement is an alias of INSERT OR REPLACE statement
-As a consequence there is no replace mode
-There is no DELETE modes
-Specifying a charset is not supported
As a consequence, the get_insert_query and get_replace_query from the abstract class have been overriden.
The index_hint method has been rewritten, have a look at it.
The property $location_delimiter has been introduced and implemented as well in MySQLDMLQueryBuilder