Whitelisting not working as expected

[yubiuser]

@BinaryDichotomy

I know for MSFT Sql Server a quick hack would be putting a trigger on a table (not ideal, but it would work)...is this possible for the db PH uses?

Yes.
For an inspiration:

Group Management question

You could add a trigger into your database, automatically adding more/other groups on creation of new clients. Note that, however, this change may be in conflict with future Pi-hole updates so you'll have to make sure to reset your local changes before updating (it will just not work, otherwise, there is no other harm involved here). The relevant triggers you'd want to look at are: (located on your system in /etc/.pihole/advanced/Templates/gravity.db.sql) They automatically add the group 0 (…