When you want to do a SQL
UPDATE using the Flutter sqflite package, I’ve found that it’s best to use their
update methods (as shown below) so you don’t have to worry about escaping single- and double-quotes. This is similar to the reason why Java developers switched from Statement to PreparedStatement way back in the late 1900s.
As an example, given this SQLite database table: