Remove SQL 'incompatible' modes

[clintropolis]

Issue for tracking removal of SQL incompatible configs from Druid, including druid.generic.useDefaultValueForNull, druid.generic.useThreeValueLogicForNativeFilters, and druid.expressions.useStrictBooleans.

Previous issue about making SQL compatible modes the default in Druid 28: #14154
PR deprecating modes in docs: #15713
dev list thread (though missing at least one reply for some reason): https://lists.apache.org/thread/016nqtdbjlkfy3r5bnxc2d4rmt79237j

[gianm]

note- we should also remove the mode detector on the home screen of web console.

[clintropolis]

note- we should also remove the mode detector on the home screen of web console.

yea, that's on my radar, and i did start to change it in the first PR, but then thought maybe would just wait until all of the configs were removed instead of partially updating each time so reverted it (same with docs)