compileUpdate method
Compile an update statement into SQL.
Implementation
@override
String compileUpdate(
Map<String, dynamic> query,
Map<String, dynamic> values,
) {
final table = wrapTable(query['table']);
final columns = values.keys.map((key) => '${wrap(key)} = ?').join(', ');
final wheres = compileWheres(query['wheres'] ?? []);
return 'UPDATE $table SET $columns $wheres'.trim();
}