Potential inconsistent data when inserting record using m2m and lookup #660
Description
Description:
When inserting new records into the main tables (e.g., User, Group), the insert succeeds, but the related many-to-many relationship insert (e.g., into the user_group join table) fails.
This results in main records being present without the required relationships, which leads to inconsistent data and potential integrity issues.
Steps to Reproduce:
sqlite-utils, version 3.38
