As I understood your question you want to have single quote in your string literals so use it double to distinguish it from the SQL command single quote , for example :
insert into names(name) values ('John')
will insert
John
, but :
insert into names(name) values ('''John''')
will insert
'John'
.
or :
insert into names(name) values ('o''reilly')
will insert
o'reilly
Hope it helps.