QueryResult *SQLExec::del(const hsql::DeleteStatement *statement) {

  Identifier table_name = statement->tableName;
  DbRelation& table = SQLExec::tables->get_table(table_name);

  EvalPlan* plan = new EvalPlan(table);

  // if(statement->expr != nullptr){
    // plan = new EvalPlan(get_where_conjunction(statement->expr),plan);
  // }

  EvalPlan* optimized = plan->optimize();

  EvalPipeline pipeline = optimized->pipeline();

    Handles* handles = pipeline.second;
  for(auto const& handle: *handles)
    table.del(handle);

  u_long n = handles->size();

  delete handles;

  return new QueryResult("DELETED statement " + n);
}