There’s a long list of reserved words when using SQLite:

http://www.sqlite.org/lang_keywords.html

A good rule of thumb is to always use backticks (“) around database table and column names to avoid reserved keyword errors when running SQLite queries.

Below is some example Objective-C code from the iPhone  SDK that shows SQLite queries being done through a wrapper class.