I am looking for some time for a MS-Acess like graphical interface addressing my large SQLite databases. Having tried out now more than dozen different packages, I found only one that fills my needs and even that only by 80% – RazorSQL.
Writing complex SQL queries is possible hwith an “autocomplete” function works but is not as powerful as the advanced H2 interface.
I like also the query builder, although it supports no LEFT OUTER but only INNER JOINS (which leaves me a lot of typing).
In addition some clauses like “WHERE table.var IN (1,2,3,4)” produce some strange results.
Is there something out there works even better with SQLite?