main.dart

import 'package:moor_ffi/database.dart';

void main() {
  final db = Database.memory();

  db.execute('''
CREATE TABLE ravs(
  id INTEGER NOT NULL PRIMARY KEY,
  originalId INTEGER NOT NULL,
  sourceId INTEGER NOT NULL,
  totalCount INTEGER NOT NULL,
  rav TEXT NOT NULL
);
  ''');
  db.execute("INSERT INTO ravs VALUES(1,1,1,1, 'הרב נתנאל אלישיב');");

  final stmt = db.prepare('SELECT * FROM ravs WHERE rav LIKE ?');

  for (final row in stmt.select(['%הרב %'])) {
    print(row);
  }
}