Navicat For SQLite

Just find an excellent GUI Admin tool for SQLite, Navucat for SQLite, which is a good alternative to SQLiteApy

Query Builder (only support SELECT)

Select records with a certain field is/isn't NULL

SELECT r_id, company_id FROM room WHERE company_id IS NOT NULL