Quick question: And
CREATE TEMP TABLE i(txt);
.separator ~
.import /home/pi/whitelist.txt i
INSERT OR IGNORE INTO whitelist (address) SELECT txt FROM i;
DROP TABLE i;
and running
sudo sqlite3 /etc/pihole/gravity.db < /home/pi/whitelists.sql
to import white list entries accordingly?