Direct Query Failing to Filter Strings With Apostrophes (ODBC: ERROR [42000])

I'm connected to a BigQuery database and am using Direct Query to access the data. When I load in a field of strings with apostrophes in some of the values (eg. "Larry's Diner"), everything will init...