insert method

@override Future<DbResult> insert(String table, Map<String, dynamic> data)

Inserts a new row into the specified table.

• data: A map of column names and values. Returns the inserted row(s) if supported.

Implementation

@override
Future<DbResult> insert(String table, Map<String, dynamic> data) async {
  final columns = data.keys.join(', ');
  final placeholders = data.keys.map(ph).join(', ');
  return rawQuery(
    'INSERT INTO $table ($columns) VALUES ($placeholders) RETURNING *;',
    values: data,
  );
}