I am sure that Adobe engineers have good reasons from adding
strong typing to SQLite but after using native version of SQLite
with manifest typing I am at a lost to understand the "improvement"
Adobe has made here.
The recommended way is to use parameterized SQL statements.
The advantage in this approach is built-in prevention of SQL
injection attacks and type safety.
When you are using parameters, you can simply assign the
value to a parameters object:
sqlStmt.text = "SELECT FROM employees WHERE first = ? and age
sqlStmt.parameters = "stringval";
// no worry about converting 10 to a string in a specific
format. Just put it as it is.
sqlStmt.parameters = 10;