What you want to do is insert the data in the database with the ' replaced with '' . This escapes the apostrophe and won't mess up the query.

Can Microsoft Copilot Write Simple SQL Commands for You? Your email has been sent Microsoft Copilot can write basic SQL code, which could help your employees be more efficient and productive.