Flutter SQLite no such column
You should use paramaters for values (especially strings)
Instead of:
await db.rawInsert( 'INSERT INTO ${DatabaseCreator.table} (${DatabaseCreator.name}) VALUES($name)');
Do something like:
await db.rawInsert( 'INSERT INTO ${DatabaseCreator.table} (${DatabaseCreator.name}) VALUES(?)', [name]);
or even simpler:
await db.insert(DatabaseCreator.table, <String, dynamic>{DatabaseCreator.name: name});