execSQL() in SQLiteDatabase is a general-purpose method for executing single SQL statements that don't return rows - primarily for queries (SELECT). For insert/update operations, Android provides dedicated methods like insert(), update(), delete() which are safer and more convenient.