PrestoSQLite

PrestoSQLite is the best ORM for sqlite written in java. It can map database tables with EntityAdapter class, which you can use to build sql query or if you don't like handling sql language you can only use entity class which provides functions to read, save and delete data from tables (CRUD) . Also with SQLiteQueryAdapter you can read data using complex query statements without directly using the sql language. To finish using the SQLBuilder class you can have your query written to be used directly with the SQLite JDBC Driver to have the best performance without unnecessary frills.