The power and memory space needed for a full-blown SQL parser are simply not available on most small devices, so not all statements that you might be accustomed to using on your desktop machine are available on an embedded device. This might change in the near future when the devices get faster. The following SQL statements can be used in UltraLite applications:
Data Manipulation Language— SELECT, INSERT, UPDATE, and DELETE statements can be included. You can use placeholders in these statements that are filled in at runtime.
TRUNCATE TABLE statement— You can use this statement to rapidly delete entire tables.
Transaction control— You can use COMMIT and ROLLBACK statements to provide transaction control within your UltraLite application. ...