For example, I am looking for something like:
...WHERE NUMBER(A) > NUMBER(B) // dummy sql
...ORDER BY NUMBER(X), STRING(Y) // dummy sql
In other words, how does one guarentee that comparisons are being interpreted as the needed or expected type? (This is assuming I don't want to pre-declare column types)
...WHERE CAST(A as INTEGER) > CAST(B as INTEGER) ...ORDER BY CAST(X as REAL), CAST(Y AS TEXT)
Kudos on Dynamic Typing
I applaud SQLite for implementing dynamic, free-form typing. Some will criticize you for it, but dynamic typing offers a lot of flexibility and "meta" ability for sophisticated programming.