String Literals
Embedded SQL string literals are delimited by single quotes. To embed a single quote in a string literal you should double it, as in:
exec sql insert
into people (age, surname)
values (15, 'O''Hara');
String literals cannot be continued over multiple lines.