The INSERT command is not generated because not all the NOT NULL columns are included in your fields selection. You must include them or set a default value in the table definition on the database