silverstripe-scienceninjas/sapphire — comment on commit 458c3afca31519a2a0daaeedea65b05c1c43c5a5
File: model/DataList.php line 274
By sminnee:

Perhaps we should have a SQLGenerator class that provide a bunch of helper methods for

$gen = DB::getnConn()->getSQLGenerator()

OR

$gen = $this->dataQuery()->query()->getSQLGenerator();

Then

$SQL_Satements[] = $gen->whereFragment_fieldNotInList($fieldName, $value);

Each database adaptor could have its own SQLGenerator subclass, the base SQLGenerator class could run pure ANSI sql.