delete method

Future<QueryResult> delete(
  1. Object table, {
  2. required Where where,
  3. Returning? returning,
})

Implementation

Future<QueryResult> delete(Object table, {required Where where, Returning? returning}) async {
  assert(where.isNotEmpty);
  SpaceBuffer buf = SpaceBuffer("DELETE FROM");
  buf << _tableNameOf(table).escapeSQL;
  buf << "WHERE";
  buf << where.sql;
  if (returning != null) {
    buf << returning.clause;
  }
  return await execute(buf.toString(), where.args);
}