MyClass->set_sql( null_somefield => <<'EOT' );
  SELECT __ESSENTIAL__
    FROM __TABLE__
    WHERE somefield IS NULL
EOT

my $iter = MyClass->search_null_somefield( );